Podcast Episodes

Postgres Best Practices? | Scaling Postgres 357

Episode 357

In this episode of Scaling Postgres, we discuss best practices, caching monitoring statistics, a new vector extension called VectorChord and the importance of monitoring wait events.

To get the show …

Published on 9 months ago

Is the Future Immutable? | Scaling Postgres 356

Episode 356

In this episode of Scaling Postgres, we discuss immutability and Postgres, the upcoming Postgres Conference in Orlando, extended statistics and usage of default partitions.

To get the show notes as w…

Published on 9 months, 1 week ago

Top Ten Analytics with pg_mooncake | Scaling Postgres 355

Episode 355

In this episode of Scaling Postgres, we discuss how Postgres & pg_mooncake achieves top ten Clickbench results, a comparison of Oracle and Postgres transactions, sharding to scale and connection coun…

Published on 9 months, 2 weeks ago

Postgres & The US Treasury Attack | Scaling Postgres 354

Episode 354

In this episode of Scaling Postgres, we discuss the role of Postgres in the US Treasury online attack, new releases of Postgres, optimizing application of streaming changes and a query that filled a …

Published on 9 months, 4 weeks ago

OLTP To Parquet For Analytics | Scaling Postgres 353

Episode 353

In this episode of Scaling Postgres, we discuss how data can flow from your OLTP to parquet files for analytics, parallel queries, view inlining and partitioning advice.

To get the show notes as well…

Published on 10 months ago

You Can Always Optimize More | Scaling Postgres 352

Episode 352

In this episode of Scaling Postgres, we discuss how you can always optimize more, avoiding deadlocks, casting & indexes and pg_hint_plan best practices.

To get the show notes as well as get notified …

Published on 10 months, 1 week ago

Features To Avoid? | Scaling Postgres 351

Episode 351

In this episode of Scaling Postgres, we talk about some features you may want to avoid like commit_delay, index_cleanup off, & logon triggers, a way to detect a table rewrite and a zero downtime upgr…

Published on 10 months, 2 weeks ago

Seven Years of Scaling Postgres | Scaling Postgres 350

Episode 350

In this episode of Scaling Postgres, we discuss our seven year anniversary, better pg_search performance, reducing table locks, not valid constraints and better group by statistics.

To get the show n…

Published on 10 months, 3 weeks ago

The Dangers of Temporary Tables | Scaling Postgres 349

Episode 349

In this episode of Scaling Postgres, we discuss the dangers of temporary tables, better transparent data encryption, pig the extension wizard, and table level lock considerations.

To get the show not…

Published on 11 months ago

The Future Is Containers? | Scaling Postgres 348

Episode 348

In this episode of Scaling Postgres, we discuss whether the future of containers and Postgres, UUIDv7 commit, and a pg_duckdb interview.

To get the show notes as well as get notified of new episodes,…

Published on 11 months, 1 week ago