Latest Episodes
293
Better Plans With Statistics | Scaling Postgres 293
In this episode of Scaling Postgres, we discuss how create statistics can help you get better plans, issues with subtransactions, all about extensions and...
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...