Latest Episodes
292

Companion Databases? | Scaling Postgres 292
In this episode of Scaling Postgres, we discuss using companion databases, multi-tenancy database design, whether SQL is good, and different transaction isolation levels. To...
291

2 To 4 Times Faster With Vectorization | Scaling Postgres 291
In this episode of Scaling Postgres, we discuss Timescale's performance improvements from adding a query vectorization pipeline, doing blue-green deployments for databases, using reserved_connections...
290

Postgres Releases = Reindexing | Scaling Postgres 290
In this episode of Scaling Postgres, we discuss my Postgres Performance Starter Kit, new releases of Postgres, removing JIT, and a lightweight message queue....
289

Postgres Scheduling Opportunities | Scaling Postgres 289
In this episode of Scaling Postgres, we discuss new options for Postgres scheduling tools, proper ways to kill processes and explain usage. To get...
288

Index Corruption From ICU Collation Change | Scaling Postgres 288
In this episode of Scaling Postgres, we discuss index corruption from a ICU collation change, another caveat for PgBouncer prepared statements, ways to version...
287

15% - 250% Faster Query Throughput | Scaling Postgres 287
In this episode of Scaling Postgres, we discuss how the new version of pgbouncer could get you 15% to 250% faster query throughput, the...