Back
Similar todos
learn more about ClickHouse and make some more optimisations 
#spectate
researching materialized view in postgres for 
#djangopackages to help clean things up
learn more about materialized views (www.postgresql.org/docs/10/ru…) 
#kornwolf
have an evening of performance tuning of ClickHouse instance to prevent hiccups that surfaced due to increased load #spectate
migrate some more queries to clickhouse and see performance become instant! #spectate
migrate to new clickhouse cluster and see INSANE latency improvements in queries! #spectate
fight against clickhouse because of sudden load increases, get it nailed and see improvements (again) #spectate
Optimize API queries with live data tables 
#scouvy
Make SQL queries less precise so Postgres can cache results 
#buildinpublic
Sketching out data models for a simple analytics platform #general
completely rewrite models for FIRE tracker so I don't have millions of queries 
#financialtoolbelt
refactoring data model 
#homestretch
started to work on a little premium feature for 
#growthhacklist - added view and first schema for marketing/growth ideas database
Ideate on streak data modeling 
#didit
Simplify and speed up almost every single database query by moving the visibility filtering logic (hide expired posts, hide all posts from hidden companies, etc) into a cached boolean column (`active`) that's updated hourly 
#startupjobs
Study Metabase for potential client business reporting 
#contracting
refactored models in preparation for domain data and scenario reports #bleakio
Rethink data model for cloud 
#nomeattoday
continue streak of improving some queries or even get rid of them entirely 🚀 #spectate