Latest Episodes
242
Reduce Replication Lag, Explain Parameterized Query, PostGIS Day, Multiple PgBouncers | Scaling Postgres 242
In this episode of Scaling Postgres, we discuss how PG15 helps reduce replication lag, how to get the parameters used in prepared statements, PostGIS...
241
Postgres 15.1, Postres 10 Retrospective, Reducing Replication Lag, Listen & Notify | Scaling Postgres 241
In this episode of Scaling Postgres, we discuss the release of Postgres 15.1, a Postgres 10 retrospective, how to reduce replication lag and using...
240
Forced Sequential Scans, Table Renaming, Terminology, PGSQL Phriday | Scaling Postgres 240
In this episode of Scaling Postgres, we discuss how sequential scans can be forced, the best way to rename a table without downtime, different...
239
Shared Buffers, Compression Algorithm, Merge Command, Postgres Contributions | Scaling Postgres 239
In this episode of Scaling Postgres, we discuss how to set shared buffers, the different WAL compression algorithm options, how to use the merge...
238
Slow Updates, Lateral Joins, Serial To Identity, PG 15 Changes | Scaling Postgres 238
In this episode of Scaling Postgres, we discuss why and what to do when updates are slow, use cases for lateral joins, moving from...
237
Postgres 15 Released, File Systems, Connection Pooling, Secure Connections | Scaling Postgres 237
In this episode of Scaling Postgres, we discuss the release of Postgres 15, the performance of different file systems with Postgres, options for connection...