In this episode of Scaling Postgres, we discuss async I/O introduced in PG 18 Beta 1, new Postgres releases, PgDog performance and innovative ways to optimize queries.
To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/365-here-comes-async-io/
Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
--------
20:01
Scaling For High Volume | Scaling Postgres 364
In this episode of Scaling Postgres, we discuss scaling for high volume, why workflows should be Postgres rows, a planner gotcha and ways to resolve planner issues.
To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/364-scaling-for-high-volume/
Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
--------
20:39
Top Ten Postgres Dos & Don'ts | Scaling Postgres 363
In this episode of Scaling Postgres, we discuss a top ten dos and don't for Postgres, understanding statistics and extended statistics, aligning columns to reduce padding and how to handle disaster recovery.
To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/363-top-ten-postgres-dos-and-donts/
Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
--------
13:32
Optimizing For Time-Series Data | Scaling Postgres 362
In this episode, we discuss optimizing for time-series data, indexing vectors, Postgres APT extension packaging and how to optimize queries involving low cardinality data columns.
To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/362-optimizing-for-time-series-data/
Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
--------
12:22
A Roadmap To Scaling Postgres | Scaling Postgres 361
In this episode of Scaling Postgres, we discuss a roadmap to scaling Postgres, life altering Postgres patterns, making Postgres better with OrioleDB, performance cliffs and efficient use of foreign keys.
To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/361-roadmap-to-scaling-postgres/
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.