Scaling Postgres Episode 161 Scaling Lessons | Synchronous Commit | Connection Management | BLOB Cleanup

In this episode of Scaling Postgres, we discuss 5 years of scaling lessons, working with synchronous commit, managing connections and cleaning up BLOBs.

Content Discussed

• Lessons Learned From 5 Years of Scaling PostgreSQL
• The Power of Synchronous_commit
• Your Guide to Connection Management in Postgres
• Cleaning up a large number of BLOBs in PostgreSQL
• Managing Transaction ID Exhaustion (Wraparound) in PostgreSQL
• Postgres is Out of Disk and How to Recover: The Dos and Don'ts
• Finally – a system level “read all data” role for PostgreSQL!
• Citus Talk at CMU: Distributed PostgreSQL as an Extension
• Benchmarking PostgreSQL: Setting up a RAID Array from Scratch
• How does Postgres handle external parameters?
• Regression Analysis in PostgreSQL with Tensorflow: Part 2 - Data Pre-processing
• Devrim Gündüz

YouTube Video