Back
Similar todos
revert release that caused slower conversations sql queries that caused 100% db cpu load and downtime
optimize postgres query add index, reduce time of run from 10 sec to less than 1 
#capgo
improve postgres settings 
#turreto
revert cascading delete reinserting 10K rows… wrote a script that takes two database backups and computes a diff psql set of commands
🚜 late night postgres database updates and a new backup system installed
upgrade postgres 10->11 
#downpayment
decrease Postgres shared buffer from 4GB to 2GB 
#startupjobs h/t @daniellockyer
change postgres plan #botletter
Upgrade Postgres from 10.16 to 13.2 
#wip
Upgrade postgres from v11 to v13 
#buildinpublic
started migrating parts of the database from PostgreSQL 
#klimy
fixed postgres deadlock
setup postgresql #highscorecoffee
Upgrade Postgres from 9.6 to 13.2 
#betalist
increase postgres' shared memory from 64mb to 512mb 
#domains
upgrade legacy postgres to managed instance on version 12, then back to 10; revisit 10->11->12 #downpayment
Upgrade WIP to a dedicated PostgreSQL database cluster, because before it was sharing the same cluster with some of my other apps would could slow down WIP at times when they were under heavy load #wip