Scaling Postgres
by Creston Jamison
Latest episode
Bare Metal Speed Postgres? | Scaling Postgres 442
Bare Metal Speed Postgres? | Scaling Postgres 442
About this podcast
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.
Episodes
The newest 50 of 442 episodes
- Bare Metal Speed Postgres? | Scaling Postgres 442 · 17 min · Episode 442In this episode of Scaling Postgres, we discuss the public beta of Oriole DB, 100,000 times faster queries with GPUs, post pg_restore to-do and a lesson in data integrity. To get…
- 100K Faster Queries With GPUs! | Scaling Postgres 441 · 20 min · Episode 441In this episode of Scaling Postgres, we discuss the public beta of Oriole DB, 100,000 times faster queries with GPUs, post pg_restore to-do and a lesson in data integrity. To get…
- 10 Million QPS . . . Efficiently | Scaling Postgres 440 · 16 min · Episode 440In this episode of Scaling Postgres, we discuss how to reach 10 million queries per second efficiently, Postgres performance on GPUs, the next release of pgrust and not trusting…
- Text Search Battle Royale! | Scaling Postgres 439 · 16 min · Episode 439In this episode of Scaling Postgres, we review two companies battling one another for text search dominance in Postgres, faster vector search with pg_vectorsearch, pushing Citus…
- Competition Is Good | Scaling Postgres 438 · 11 min · Episode 438In this episode of Scaling Postgres, we discuss performance improvements in ParadeDB as a result of PlanetScale, an open source BM25 index from PGX Inc., pgbouncer and pgvector…
- The Reason For Reversions | Scaling Postgres 437 · 17 min · Episode 437In this episode of Scaling Postgres, we discuss the reasons for all the PG 19 reversions, why open source wins, the cost of REPACK CONCURRENTLY and hint implementations. To get…
- Postgres 19 Beta 4 Released! | Scaling Postgres 436 · 12 min · Episode 436In this episode of Scaling Postgres, we discuss PG19 Beta 4, pgBouncer CVEs, managed provider security and transferring data to Clickhouse using physical replication. To get the…
- Postgres 19 Revert Train! | Scaling Postgres 435 · 11 min · Episode 435In this episode of Scaling Postgres, we discuss possibly twelve different feature reversions in Postgres 19 and why, the impact of one more index, the cost of a single insert and…
- Postgres 19 Reversions | Scaling Postgres 434 · 12 min · Episode 434In this episode of Scaling Postgres, we discuss various reversions and the uncertain release date of Postgres 19, pgSafe a new backup solution written in Go, inserting state…
- Read After Write | Scaling Postgres 433 · 17 min · Episode 433In this episode of Scaling Postgres, we see examples of using WAIT FOR in PG 19 for handling read after write, local NVME vs block store, new system views and the ambiguity of…
- 23 Times Faster Inserts With UUIDv7 | Scaling Postgres 432 · 16 min · Episode 432In this episode of Scaling Postgres, we discuss getting 23 times faster inserts with UUIDv7, the benefits and downsides of UUIDs, how to optimize queries without table changes…
- pg_rust Co-Creator postgres.fm Interview | Scaling Postgres 431 · 11 min · Episode 431In this episode of Scaling Postgres, we cover postgres.fm's interview of pgrust co-creator Michael Malis, pgDog vs RDS Proxy, Postgres on Kubernetes in 10 minutes and evolution…
- 28 Security Vulnerabilities | Scaling Postgres 430 · 10 min · Episode 430In this episode of Scaling Postgres, we discuss new releases fixing 28 security vulnerabilities, more MVCC, BYOK encryption and should Postgres include pgbouncer. To get the show…
- 300 Times Faster Analytics With pgrust | Scaling Postgres 429 · 13 min · Episode 429In this episode of Scaling Postgres, we discuss pgrust running analytical queries 300 times faster than Postgres, how to speed up distinct count, Xata podcast and massively…
- Postgres MVCC Is Bad? | Scaling Postgres 428 · 17 min · Episode 428In this episode of Scaling Postgres, we discuss how bad Postgres MVCC is, a startup's survival guide for Postgres, an examination of DBOS, and different ways of performing hybrid…
- Migrating to pg_hardstorage | Scaling Postgres 427 · 8 min · Episode 427In this episode of Scaling Postgres, we discuss migrating to pg_hardstorage for Postgres backup, PG 19 Beta 2 is released, collecting log stats with pg_stat_log and PG 19…
- pgrust Faster Than Postgres? | Scaling Postgres 426 · 16 min · Episode 426In this episode of Scaling Postgres, we discuss the progress of the Rust rewrite of Postgres called pgrust, more about the backup tool pg_hardstorage, beware listen / notify and…
- Novel Partition Exclusion | Scaling Postgres 425 · 17 min · Episode 425In this episode of Scaling Postgres, we discuss excluding partitions without using a partition key, a pgBackRest interview, Postgres backup without an incremental chain and a…
- Too Many Table Danger | Scaling Postgres 424 · 15 min · Episode 424In this episode of Scaling Postgres, we discuss the dangers of too many tables, don't worry about extending checkpoint_timeout, a disaster recovery process, and non-repeatable…
- New Backup Tool | Scaling Postgres 423 · 15 min · Episode 423In this episode of Scaling Postgres, we discuss a new backup tool called pg_hardstorage by Cybertech, bottomless storage & ColdFront, monitoring checkpoints and tracking…
- Scaling Out To 226K TPS | Scaling Postgres 422 · 13 min · Episode 422In this episode of Scaling Postgres, we discuss scaling out application writes to achieve 226K TPS, try to avoid delete, disaster recovery is a process and avoid NULL in your NOT…
- Scale Out Funding | Scaling Postgres 421 · 10 min · Episode 421In this episode of Scaling Postgres, we discuss scale out Postgres projects getting more funding, getting started with Postgres 19 Beta 1 along with its top features and how to…
- Postgres 19 Beta 1 Released | Scaling Postgres 420 · 19 min · Episode 420In this episode of Scaling Postgres, we discuss the release of Postgres 19 Beta 1, optimizing autovacuum, the release of Multigres 0.1 Alpha 1, and handling graph queries in…
- The Dynamic Duo? | Scaling Postgres 419 · 16 min · Episode 419In this episode of Scaling Postgres, we go over the architecture of Multigres (Vitess for Postgres), pgBackRest's status, pg_flight_recorder and general SQL optimizations. To get…
- Multigres Architecture | Scaling Postgres 418 · 17 min · Episode 418In this episode of Scaling Postgres, we go over the architecture of Multigres (Vitess for Postgres), pgBackRest's status, pg_flight_recorder and general SQL optimizations. To get…
- 11 Security Issues | Scaling Postgres 417 · 20 min · Episode 417In this episode of Scaling Postgres, we discuss new Postgres releases that patch eleven security issues, a new pgbouncer release patching four security issues, making JSON…
- Zero Bloat Postgres Queue | Scaling Postgres 416 · 15 min · Episode 416In this episode of Scaling Postgres, we discuss a new zero bloat Postgres queue called PgQue, maybe pgBackRest isn't dead, multixact members at 64 bits and using session…
- pgBackRest Is Dead? | Scaling Postgres 415 · 16 min · Episode 415In this episode of Scaling Postgres, we discuss the notice of obsolescence for pgBackRest, the open source environment in general, queries to monitor autovacuum and…
- Repack Concurrently | Scaling Postgres 414 · 20 min · Episode 414In this episode of Scaling Postgres, we discuss repack concurrently coming to PG 19, how to design your schema, all about hints and enforcing constraints across partitions. To…
- Shard With One Command | Scaling Postgres 413 · 20 min · Episode 413In this episode of Scaling Postgres, we discuss sharding your database with one command, more information about the Linux 7 Postgres performance regression, Xata going open…
- Half as Fast on Linux 7 | Scaling Postgres 412 · 16 min · Episode 412In this episode of Scaling Postgres, we discuss how Postgres may be half as fast on the new Linux 7 kernel, PostgresBench, what is missing in Postgres and WAL to distribute data…
- Absorbing Load | Scaling Postgres 411 · 20 min · Episode 411In this episode of Scaling Postgres, we discuss techniques to absorb excessive query load, BM25 text search via pg_textsearch, good & bad CTEs and plan_cache_mode. To get the…
- Postgres Traffic Cop! | Scaling Postgres 410 · 12 min · Episode 410In this episode of Scaling Postgres, we discuss a proprietary way of controlling Postgres query traffic, preserving statistics during upgrades, a DB schema migration survey and a…
- Iceberg Causes Postgres Acquisitions? | Scaling Postgres 409 · 14 min · Episode 409In this episode of Scaling Postgres, we discuss how Apache Iceberg may have lead to Postgres company acquisitions, presentations on CloudNativePG & query tuning, setting up…
- Open Source Eating The World | Scaling Postgres 408 · 17 min · Episode 408In 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…
- Stable Plans? | Scaling Postgres 407 · 19 min · Episode 407In 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…
- Lock Causes Data To Vanish! | Scaling Postgres 406 · 18 min · Episode 406In 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…
- Out of Cycle Releases | Scaling Postgres 405 · 17 min · Episode 405In 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…
- Postmaster Does Not Scale! | Scaling Postgres 404 · 17 min · Episode 404In 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…
- Mitigate Retry Storms? | Scaling Postgres 403 · 16 min · Episode 403In 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…
- Millions of QPS | Scaling Postgres 402 · 18 min · Episode 402In 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…
- One Billion Vectors On Postgres | Scaling Postgres 401 · 22 min · Episode 401In 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…
- The Cost of Arrays | Scaling Postgres 400 · 18 min · Episode 400In 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…
- Index Overhead? | Scaling Postgres 399 · 19 min · Episode 399In 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…
- Latency Killing Performance? | Scaling Postgres 398 · 20 min · Episode 398In 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…
- Vacuum Is Lying To You? | Scaling Postgres 397 · 17 min · Episode 397In 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…
- 600 Times Faster Analytics | Scaling Postgres 396 · 19 min · Episode 396In 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…
- 16 Times Faster Join Plans | Scaling Postgres 395 · 16 min · Episode 395In 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…
- 5 Times Faster Aggregates | Scaling Postgres 394 · 16 min · Episode 394In 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…
- Job Security? | Scaling Postgres 393 · 15 min · Episode 393In 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…
