Scaling Postgres

By Creston JamisonTechnology

Scaling Postgres episodes

March 15 Open Source Eating The World | Scaling Postgres 408
In this episode of Scaling Postgres, we discuss how open source is eating the world, mitigating plan flips, migrating from Heroku to RDS, and how work_mem is a trap.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/408-open-source-eating-the-world/
Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
18 min
March 08 Stable Plans? | Scaling Postgres 407
In this episode of Scaling Postgres, we discuss the possibility of having stable plans in Postgres 19, settings to kill disconnected or crashed clients, on conflict do select and all about Patroni.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/407-stable-plans/
Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
19 min
March 01 Lock Causes Data To Vanish! | Scaling Postgres 406
In this episode of Scaling Postgres, we discuss how a lock can cause data to vanish, new Postgres releases, fast replication with peerDB and pg_ash for wait sampling.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/406-lock-causes-data-to-vanish/
Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
19 min
February 22 Out of Cycle Releases | Scaling Postgres 405
In this episode of Scaling Postgres, we discuss an out of cycle Postgres release, a Supabase downtime incident, optimizing top K queries and how to maintain reading efficiency.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/405-out-of-cycle-releases/
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 min
February 15 Postmaster Does Not Scale! | Scaling Postgres 404
In this episode of Scaling Postgres, we discuss how the postmaster does not scale, new Postgres releases, data storage using PAX and a path generation strategies change.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/404-postmaster-does-not-scale/
Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
18 min
February 08 Mitigate Retry Storms? | Scaling Postgres 403
In this episode of Scaling Postgres, we discuss a potential way to mitigate retry storms or orphan DB sessions with client_connection_check_interval, checkpoint configuration, skip scans and more just use Postgres.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/403-mitigate-retry-storms/
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 min
February 01 Millions of QPS | Scaling Postgres 402
In this episode of Scaling Postgres, we discuss how OpenAI's ChatGPT handles millions of queries per second, an update on PgDog, Clickhouse offers OLTP hosted Postgres and partition table source of truth.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/402-millions-of-qps/
Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
19 min
January 25 One Billion Vectors On Postgres | Scaling Postgres 401
In this episode of Scaling Postgres, we discuss searching one billion vectors on Postgres, how to bypass a vector index search, unconventional optimizations and a 40x boost to listen/notify performance.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/401-one-billion-vectors-on-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/
23 min
January 18 The Cost of Arrays | Scaling Postgres 400
In this episode of Scaling Postgres, we discuss the cost of arrays, dealing with integer overflow, idle sessions causing transaction wraparound and AI or LLM index recommendations.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/400-the-cost-of-arrays/
Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
18 min
January 11 Index Overhead? | Scaling Postgres 399
In this episode of Scaling Postgres, we discuss the overhead of indexes, a Postgres year in review, an intro to row locking and table renaming issues.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/399-index-overhead/
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 min

About Scaling Postgres

From the publisher's feed

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…