Scaling Out To 226K TPS | Scaling Postgres 422

To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episo... In this episode of Scaling Postgres, we discuss scaling out application writes to achieve 226K TPS, try to avoid delete, disaster recovery is a process and avoid NULL in your NOT IN. Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/cours... Timestamps: 00:25 - From Christmas Outage to #1 App Store Ranking: An Aura Frames Postgres Scaling Retrospective 02:42 - Scaling Rails at Aura Frames: Splitting to 8 Primary DBs and Reaching #1 in the App Store 03:37 - The only scalable delete in Postgres is DROP TABLE 03:29 - Disaster Recovery is a Process, Not a Tool (Part 1) 07:21 - The NULL in your NOT IN 09:11 - Looking Forward to Postgres 19: It's About Time 10:22 - British Columbia, Time Zones, and Postgres 11:18 - pg_kpart PostgreSQL extension 11:55 - A thousand Postgres branches for $1 How I got started running a Postgres user group with Jeremy Schneider 13:07 - Outro #postgres #postgresql