Latest Episodes
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...
236
Postgres 15 RC2, Shared Buffers, Secure Connections, PGSQL Phriday | Scaling Postgres 236
In this episode of Scaling Postgres, we discuss the Postgres 15 RC2, optimizing shared buffers, how to secure your database connections and blog posts...
235
Postgres 15 RC1, ICU Collations, Listen & Notify, Understanding TOAST | Scaling Postgres 235
In this episode of Scaling Postgres, we discuss the release of the Postgres 15 Release Candidate 1, new ICU collations features, how to use...