Back
Similar todos
Load previous page…
more testing with postgres & other variants 
#businessshadow
try to use a postgres function and loop to do some intensive code but get cryptic error messages and end up using JS instead
set query cache to test 
#taskcrunch
add caching columns for post votes 
#wip
Enable pg_stat_statements on 
#simpleanalytics database
optimize MySQL query cache size by reducing its size to prevent super high cpu usage managing the cache 
#crisp
Randomize results from 
#eunoia queries and limit results for given query
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
researching materialized view in postgres for 
#djangopackages to help clean things up
learned postgresql trigger functions
Readjust Postgresql and pgpool configs for connection limitations 
#netlandish
fix slow query 
#rewardsflights
Roll back package that was meant to speed things up but slowed requests by 3x and 10x in postgres.