PLAY PODCASTS
Scaling Postgres

Scaling Postgres

443 episodes — Page 1 of 9

Postgres Releases & 52 Security Fixes | Scaling Postgres 443

Nov 15, 202617 min

Bare Metal Speed Postgres? | Scaling Postgres 442

Nov 8, 202617 min

100K Faster Queries With GPUs! | Scaling Postgres 441

Nov 1, 202619 min

10 Million QPS . . . Efficiently | Scaling Postgres 440

Oct 25, 202615 min

Text Search Battle Royale! | Scaling Postgres 439

Oct 18, 202616 min

Competition Is Good | Scaling Postgres 438

Oct 11, 202611 min

The Reason For Reversions | Scaling Postgres 437

Oct 4, 202616 min

Postgres 19 Beta 4 Released! | Scaling Postgres 436

Sep 27, 202612 min

Postgres 19 Revert Train! | Scaling Postgres 435

Sep 20, 202610 min

Postgres 19 Reversions | Scaling Postgres 434

Sep 13, 202611 min

Read After Write | Scaling Postgres 433

Sep 6, 202616 min

23 Times Faster Inserts With UUIDv7 | Scaling Postgres 432

Aug 30, 202615 min

pg_rust Co-Creator postgres.fm Interview | Scaling Postgres 431

Aug 23, 202611 min

28 Security Vulnerabilities | Scaling Postgres 430

Aug 16, 202610 min

300 Times Faster Analytics With pgrust | Scaling Postgres 429

Aug 9, 202613 min

Postgres MVCC Is Bad? | Scaling Postgres 428

Aug 2, 202617 min

Migrating to pg_hardstorage | Scaling Postgres 427

Jul 26, 20268 min

pgrust Faster Than Postgres? | Scaling Postgres 426

Jul 19, 202615 min

Novel Partition Exclusion | Scaling Postgres 425

Jul 12, 202617 min

Too Many Table Danger | Scaling Postgres 424

Jul 5, 202615 min

New Backup Tool | Scaling Postgres 423

Jun 28, 202614 min

Scaling Out To 226K TPS | Scaling Postgres 422

Jun 21, 202613 min

Scale Out Funding | Scaling Postgres 421

Jun 14, 20269 min

Postgres 19 Beta 1 Released | Scaling Postgres 420

Jun 7, 202618 min

The Dynamic Duo? | Scaling Postgres 419

May 31, 202615 min

Multigres Architecture | Scaling Postgres 418

May 24, 202616 min

11 Security Issues | Scaling Postgres 417

May 17, 202619 min

Zero Bloat Postgres Queue | Scaling Postgres 416

May 10, 202615 min

pgBackRest Is Dead? | Scaling Postgres 415

May 3, 202616 min

Repack Concurrently | Scaling Postgres 414

Apr 26, 202619 min

Shard With One Command | Scaling Postgres 413

Apr 19, 202619 min

Half as Fast on Linux 7 | Scaling Postgres 412

Apr 12, 202615 min

Absorbing Load | Scaling Postgres 411

Apr 5, 202619 min

Ep 410Postgres Traffic Cop! | Scaling Postgres 410

In 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 new repack command. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/410-postgres-traffic-cop/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

Mar 29, 202612 min

Ep 409Iceberg Causes Postgres Acquisitions? | Scaling Postgres 409

In this episode of Scaling Postgres, we discuss how Apache Iceberg may have lead to Postgres company acquisitions, presentations on CloudNativePG & query tuning, setting up Patroni and utilizing PgBouncer. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/409-iceberg-causes-postgres-acquisitions/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

Mar 22, 202614 min

Ep 408Open 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/

Mar 15, 202617 min

Ep 407Stable 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/

Mar 8, 202618 min

Ep 406Lock 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/

Mar 1, 202618 min

Ep 405Out 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/

Feb 22, 202616 min

Ep 404Postmaster 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/

Feb 15, 202617 min

Ep 403Mitigate 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/

Feb 8, 202616 min

Ep 402Millions 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/

Feb 1, 202618 min

Ep 401One 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/

Jan 25, 202622 min

Ep 400The 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/

Jan 18, 202617 min

Ep 399Index 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/

Jan 11, 202619 min

Ep 398Latency Killing Performance? | Scaling Postgres 398

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/

Jan 4, 202619 min

Ep 397Vacuum Is Lying To You? | Scaling Postgres 397

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/

Dec 21, 202516 min

Ep 396600 Times Faster Analytics | Scaling Postgres 396

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/

Dec 14, 202518 min

Ep 39516 Times Faster Join Plans | Scaling Postgres 395

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/

Dec 7, 202516 min

Ep 3945 Times Faster Aggregates | Scaling Postgres 394

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/

Nov 30, 202516 min