Latest Episodes
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...
286
20 Times Faster Text Search & Ranking? | Scaling Postgres 286
In this episode of Scaling Postgres, we discuss a new extension that promises substantially faster text search and ranking, an AI content storm, how...