Latest Episodes
353

OLTP To Parquet For Analytics | Scaling Postgres 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...
352

You Can Always Optimize More | Scaling Postgres 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...
351

Features To Avoid? | Scaling Postgres 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...
350

Seven Years of Scaling Postgres | Scaling Postgres 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...
349

The Dangers of Temporary Tables | Scaling Postgres 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...
348

The Future Is Containers? | Scaling Postgres 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...