Podcast Episodes

Boosting Planning Performance | Scaling Postgres 387

Episode 387

In this episode of Scaling Postgres, we explore how PG18 locking changes can boost planning performance, how to store data safely on a budget, how to build a parquet file archive solution and we disc…

Published on 2 months, 1 week ago

Postgres 18: The Deep Cuts | Scaling Postgres 386

Episode 368

In this episode of Scaling Postgres, we discuss additional Postgres 18 features, some future features for Postgres, how to use update with limit and how recent Ubuntu OS patches cause a Postgres rest…

Published on 2 months, 2 weeks ago

Postgres 18 Released! | Scaling Postgres 385

Episode 385

In this episode of Scaling Postgres, we discuss the release of Postgres 18 and cover different features such as asynchronous I/O, enhanced return from statements, parallel apply, adding not null as n…

Published on 2 months, 3 weeks ago

Preparing For Postgres 18 | Scaling Postgres 384

Episode 384

In this episode of Scaling Postgres, we discuss getting excited about Postgres 18, oauth authentication, reconsidering your interface and a zero downtime upgrade.

To get the show notes as well as get…

Published on 3 months ago

OrioleDB More Free? | Scaling Postgres 383

Episode 383

In this episode of Scaling Postgres, we discuss free availability of an OrioleDB patent, pgEdge going open source, pg_duckdb hitting 1.0 and methods resolve to slow order by limit queries.

To get the…

Published on 3 months, 1 week ago

DB LLM Agents? | Scaling Postgres 382

Episode 382

In this episode of Scaling Postgres, we discuss using a LLM as an agent, the importance of partitioned table statistics, PG 18 RC1, primary keys in sharded databases and a blue/green rollback.

To get…

Published on 3 months, 2 weeks ago

DocumentDB Movement | Scaling Postgres 381

Episode 381

In this episode of Scaling Postgres, we discuss DocumentDB moving to the Linux Foundation, multi-column indexes, SCRAM pass-through and RDS Proxy oddities.

To get the show notes as well as get notifi…

Published on 3 months, 3 weeks ago

Storage Engine Progress? | Scaling Postgres 380

Episode 380

In this episode of Scaling Postgres, we discuss enhancements to Oriole DB, new Postgres releases, a logging guide and application framework frustrations.

To get the show notes as well as get notified…

Published on 3 months, 3 weeks ago

Unconventional Advice? | Scaling Postgres 379

Episode 379

In this episode of Scaling Postgres, we discuss when you should reindex, how to handle case insensitive data, how to index jsonb and the top recommendations when doing performance optimizations.

To g…

Published on 4 months ago

Native Column Store? | Scaling Postgres 378

Episode 378

In this episode of Scaling Postgres, we discuss Postgres getting a native column store via an index, faster btree_gift indexes, scaling listen/notify, and a logical replication slot deep dive.

To get…

Published on 4 months, 1 week ago