Scaling PostgreSQL

A free weekly show on how to scale your PostgreSQL relational database.
Join over a thousand engineers keeping current on relevant Postgres content.

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 and partitioning advice.

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.

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 way to detect a table rewrite and a zero downtime upgrade.

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 by statistics.

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 lock considerations.

Full Episode List