Claim OwnershipScaling Postgres
Subscribed: 117Played: 6,025
Subscribe
© 2023
Description
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.
408 Episodes
Reverse
In this episode of Scaling Postgres, we discuss Citus 10 open source, time series performance in native Postgres, using subscripting for updates and new target_session_attrs.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/155-citus-open-source-time-series-performance-subscripting-updates-target_session_attrs/
In this episode of Scaling Postgres, we discuss the PGMiner botnet attack, how collation changes can cause index corruption, managing your postgresql.conf and implementing custom data types.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/145-pgminer-botnet-attack-collation-index-corruption-postgresqlconf-custom-data-types/
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/
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/
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/
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/
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/
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/
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/
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/
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/
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/
In this episode of Scaling Postgres, we examine how latency impacts performance, naughty queries, bm25 indexes and how to quickly create database clones.
To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/398-latency-killing-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 if vacuum is lying to you with regard to index cleanup, an agentic toolkit with MCP server, indexes getting corrupted after an upgrade and $50 Planetscale Metal.
To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/397-vacuum-is-lying-to-you/
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 Postgres queries in ClickHouse, faster faceted search, max_connections & migrations and different scan types.
To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/396-600-times-faster-analytics/
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 patch that can plan joins 16 times faster, the best way to record text values, extensions via image volumes with CloudNativePG and using pg_partman vs rolling your own.
To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/395-16-times-faster-join-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/
In this episode of Scaling Postgres, we discuss my Black Friday / Cyber Monday course deal, the job security that LLMs provide, new Postgres releases and why you should hard your datbase.
To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/394-five-times-faster-aggregates/
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 my Black Friday / Cyber Monday course deal, the job security that LLMs provide, new Postgres releases and why you should shard your database.
To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/393-job-security/
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 performance improvements related to skip scans, faster backup & restore, benefits of minimal indexes and more details about my upcoming course discount.
To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/392-100-times-faster-by-skipping/
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 issues of partition locking during planning, the problem of too much memory, the importance of a txvector column and an upcoming sale on my course.
To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/391-table-lock-explosion/
Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
Download from Google Play
Download from App Store
United States
I know MySQL provides Master-Standby replication, while this postgres explanation plan https://www.devart.com/dbforge/postgresql/studio/postgresql-explain.html supports it and has improved WAL processing, allowing near real-time replication and fallback with minimal downtime for standby servers.