Scaling Postgres

Learn how to get the best performance and scale your PostgreSQL database with our weekly shows. Receive the best content curated from around the web. We have a special focus on content for developers since ...more

Hosted by

Latest Episodes

241

November 13, 2022 00:17:53
Postgres 15.1, Postres 10 Retrospective, Reducing Replication Lag, Listen & Notify | Scaling Postgres 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...

Listen

240

November 06, 2022 00:19:17
Forced Sequential Scans, Table Renaming, Terminology, PGSQL Phriday | Scaling Postgres 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...

Listen

239

October 30, 2022 00:15:18
Shared Buffers, Compression Algorithm, Merge Command, Postgres Contributions | Scaling Postgres 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...

Listen

238

October 24, 2022 00:13:05
Slow Updates, Lateral Joins, Serial To Identity, PG 15 Changes | Scaling Postgres 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...

Listen

237

October 16, 2022 00:18:53
Postgres 15 Released, File Systems, Connection Pooling, Secure Connections | Scaling Postgres 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...

Listen

236

October 10, 2022 00:19:54
Postgres 15 RC2, Shared Buffers, Secure Connections, PGSQL Phriday | Scaling Postgres 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...

Listen