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

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

235

October 03, 2022 • 00:16:21
Postgres 15 RC1, ICU Collations, Listen & Notify, Understanding TOAST | Scaling Postgres 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...

Listen

234

September 25, 2022 • 00:16:20
Rust for Extensions, Timescale vs. Postgres, Uninterrupted Sharding, Data Flow | Scaling Postgres 234

Rust for Extensions, Timescale vs. Postgres, Uninterrupted Sharding, Data Flow | Scaling Postgres 234

In this episode of Scaling Postgres, we discuss using rust for Postgres extensions, performance comparisons of TimescaleDB vs. Postgres, uninterrupted writes when sharding in...

Listen