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/
-------- Â
15:54
--------
15:54
Postgres 18: The Deep Cuts | Scaling Postgres 386
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/
-------- Â
15:03
--------
15:03
Postgres 18 Released! | Scaling Postgres 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 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/
-------- Â
17:07
--------
17:07
Preparing For Postgres 18 | Scaling Postgres 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 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/
-------- Â
17:25
--------
17:25
OrioleDB More Free? | Scaling Postgres 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 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/
Learn how to get the best performance and scale your PostgreSQL database with our weekly shows. Receive the best content curated from around the web. We have a special focus on content for developers since your architecture and usage is the key to getting the most performance out of PostgreSQL.
Ireland