In this episode of Scaling Postgres, we discuss how far Postgres can scale with queue and pub/sub workloads, temporal joins, IPC:SyncRep and nested partitioning.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/390-1.2-million-messages-per-second/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

In this episode of Scaling Postgres, we discuss ways to optimize reading or writing, the benefits of a descending index, more information about lightweight locks and a backup public service announcement.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/389-heavy-reader-or-writer/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

In this episode of Scaling Postgres, we discuss PG17 and PG18 benchmarks across storage types, more about Postgres locks, sanitizing SQL and can a faster software & hardware environment cause performance problems?

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/388-nvme-wins/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

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 discuss the completion of the summer of upgrades.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/387-boosting-planning-performance/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

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 restart.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/386-postgres-18-the-deep-cuts/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

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 not valid and more!

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/385-postgres-18-released/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

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 notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/384-preparing-for-postgres-18/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

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 show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/383-orioledb-more-free/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

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 the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/382-db-llm-agents/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

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 notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/381-documentdb-movement/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/