Scaling Postgres

In this episode of Scaling Postgres, we discuss the benefits of using time-based UUIDv7 vs UUIDv4 for primary keys, how OpenAI uses Postgres, handling locks and methods to migrate to partition tables with low downtime.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/368-4-times-faster-uuid-primary-keys/

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 a Postgres VS code extension, service definition files, undead tuples and the benefits of finding out how often a query is run.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/367-how-often-does-that-query-run/

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 a top ten dangerous Postgres issues list, importing and exporting statistics, more Postgres 18 beta features and a 20,000 times faster query by fixing an order by limit issue.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/366-20k-faster-order-by-limit/

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 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/

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/

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/

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/

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/

In this episode of Scaling Postgres, we discuss how a new tool pgDog might allow one million client connections to Postgres, novel use cases for pgvector other than semantic search, don't expose port 5432 and Postgres on Kubernetes.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/360-handle-one-million-connections/

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 talk about indexes being added to Timescale's column store, processing 1 trillion metrics in Timescale, processing 1 trillion rows in Citus and partitions for deletion use cases.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/359-trillions-of-rows-and-metrics/

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