Scaling Postgres
Episodes
Half as Fast on Linux 7 | Scaling Postgres 412
12 Apr 2026
Contributed by Lukas
In 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...
Absorbing Load | Scaling Postgres 411
05 Apr 2026
Contributed by Lukas
In this episode of Scaling Postgres, we discuss techniques to absorb excessive query load, BM25 text search via pg_textsearch, good & bad CTEs and...
Postgres Traffic Cop! | Scaling Postgres 410
29 Mar 2026
Contributed by Lukas
In this episode of Scaling Postgres, we discuss a proprietary way of controlling Postgres query traffic, preserving statistics during upgrades, a DB s...
Iceberg Causes Postgres Acquisitions? | Scaling Postgres 409
22 Mar 2026
Contributed by Lukas
In this episode of Scaling Postgres, we discuss how Apache Iceberg may have lead to Postgres company acquisitions, presentations on CloudNativePG &...
Open Source Eating The World | Scaling Postgres 408
15 Mar 2026
Contributed by Lukas
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...
Stable Plans? | Scaling Postgres 407
08 Mar 2026
Contributed by Lukas
In this episode of Scaling Postgres, we discuss the possibility of having stable plans in Postgres 19, settings to kill disconnected or crashed client...
Lock Causes Data To Vanish! | Scaling Postgres 406
01 Mar 2026
Contributed by Lukas
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 fo...
Out of Cycle Releases | Scaling Postgres 405
22 Feb 2026
Contributed by Lukas
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 ma...
Postmaster Does Not Scale! | Scaling Postgres 404
15 Feb 2026
Contributed by Lukas
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...
Mitigate Retry Storms? | Scaling Postgres 403
08 Feb 2026
Contributed by Lukas
In this episode of Scaling Postgres, we discuss a potential way to mitigate retry storms or orphan DB sessions with client_connection_check_interval, ...
Millions of QPS | Scaling Postgres 402
01 Feb 2026
Contributed by Lukas
In this episode of Scaling Postgres, we discuss how OpenAI's ChatGPT handles millions of queries per second, an update on PgDog, Clickhouse offers OLT...
One Billion Vectors On Postgres | Scaling Postgres 401
25 Jan 2026
Contributed by Lukas
In this episode of Scaling Postgres, we discuss searching one billion vectors on Postgres, how to bypass a vector index search, unconventional optimiz...
The Cost of Arrays | Scaling Postgres 400
18 Jan 2026
Contributed by Lukas
In this episode of Scaling Postgres, we discuss the cost of arrays, dealing with integer overflow, idle sessions causing transaction wraparound and AI...
Index Overhead? | Scaling Postgres 399
11 Jan 2026
Contributed by Lukas
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....
Latency Killing Performance? | Scaling Postgres 398
04 Jan 2026
Contributed by Lukas
In this episode of Scaling Postgres, we examine how latency impacts performance, naughty queries, bm25 indexes and how to quickly create database clon...
Vacuum Is Lying To You? | Scaling Postgres 397
21 Dec 2025
Contributed by Lukas
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 ge...
600 Times Faster Analytics | Scaling Postgres 396
14 Dec 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss using Postgres queries in ClickHouse, faster faceted search, max_connections & migrations and diff...
16 Times Faster Join Plans | Scaling Postgres 395
07 Dec 2025
Contributed by Lukas
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 ...
5 Times Faster Aggregates | Scaling Postgres 394
30 Nov 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss my Black Friday / Cyber Monday course deal, the job security that LLMs provide, new Postgres releases ...
Job Security? | Scaling Postgres 393
23 Nov 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss my Black Friday / Cyber Monday course deal, the job security that LLMs provide, new Postgres releases ...
100 Times Faster By Skipping! | Scaling Postgres 392
16 Nov 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss performance improvements related to skip scans, faster backup & restore, benefits of minimal index...
Table Lock Explosion! | Scaling Postgres 391
09 Nov 2025
Contributed by Lukas
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 t...
1.2 Million Messages Per Second | Scaling Postgres 390
02 Nov 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss how far Postgres can scale with queue and pub/sub workloads, temporal joins, IPC:SyncRep and nested pa...
Heavy Reader or Writer? | Scaling Postgres 389
26 Oct 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss ways to optimize reading or writing, the benefits of a descending index, more information about lightw...
NVME Wins? | Scaling Postgres 388
19 Oct 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss PG17 and PG18 benchmarks across storage types, more about Postgres locks, sanitizing SQL and can a fas...
Boosting Planning Performance | Scaling Postgres 387
12 Oct 2025
Contributed by Lukas
In this episode of Scaling Postgres, we explore how PG18 locking changes can boost planning performance, how to store data safely on a budget, how to ...
Postgres 18: The Deep Cuts | Scaling Postgres 386
05 Oct 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss additional Postgres 18 features, some future features for Postgres, how to use update with limit and h...
Postgres 18 Released! | Scaling Postgres 385
28 Sep 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss the release of Postgres 18 and cover different features such as asynchronous I/O, enhanced return from...
Preparing For Postgres 18 | Scaling Postgres 384
21 Sep 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss getting excited about Postgres 18, oauth authentication, reconsidering your interface and a zero downt...
OrioleDB More Free? | Scaling Postgres 383
14 Sep 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss free availability of an OrioleDB patent, pgEdge going open source, pg_duckdb hitting 1.0 and methods r...
DB LLM Agents? | Scaling Postgres 382
07 Sep 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss using a LLM as an agent, the importance of partitioned table statistics, PG 18 RC1, primary keys in sh...
DocumentDB Movement | Scaling Postgres 381
31 Aug 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss DocumentDB moving to the Linux Foundation, multi-column indexes, SCRAM pass-through and RDS Proxy oddi...
Storage Engine Progress? | Scaling Postgres 380
24 Aug 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss enhancements to Oriole DB, new Postgres releases, a logging guide and application framework frustratio...
Unconventional Advice? | Scaling Postgres 379
17 Aug 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss when you should reindex, how to handle case insensitive data, how to index jsonb and the top recommend...
Native Column Store? | Scaling Postgres 378
10 Aug 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss Postgres getting a native column store via an index, faster btree_gift indexes, scaling listen/notify,...
Sharding At Network Speeds | Scaling Postgres 377
03 Aug 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss how to shard your DB at network speeds, how to make your DB 42,000 slower, new monitoring and just eno...
100K Events Per Second Queue | Scaling Postgres 376
27 Jul 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss a 100K events per second queue built on Postgres, how an MCP can leak your database, MultiXact ID and ...
All The Benchmarks | Scaling Postgres 375
20 Jul 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss new benchmarks as a result of the Planetscale Postgres announcement, various platform improvements and...
Migrating Millions Of Databases | Scaling Postgres 374
13 Jul 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss how Jira migrated millions of databases, when sigterm does nothing, should you ditch vector search and...
Planetscale Postgres! | Scaling Postgres 373
06 Jul 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss the release of Planetscale Postgres and the advantages for bare metal, how often queries are optimal, ...
The Future of Postgres Architecture | Scaling Postgres 372
29 Jun 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss some possible futures for Postgres architectures, choosing a multi-tenancy model, vectors in the new S...
Are You Hurting Your Performance? | Scaling Postgres 371
22 Jun 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss how you use the database can impact its performance, performance of pg_search, fast uploads and some d...
New Scale Out Options | Scaling Postgres 370
15 Jun 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss the start of Multigres which is a Vitess for Postgres, pgactive going open source, getting started wit...
Move Off Of RDS? | Scaling Postgres 369
08 Jun 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss why and how you could move off of AWS RDS, Snowflake acquires Crunchy Data, reducing your SQL queries ...
4 Times Faster UUID Primary Keys | Scaling Postgres 368
01 Jun 2025
Contributed by Lukas
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...
How Often Does That Query Run? | Scaling Postgres 367
25 May 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss a Postgres VS code extension, service definition files, undead tuples and the benefits of finding out ...
20,000 Times Faster Order By Limit | Scaling Postgres 366
18 May 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss a top ten dangerous Postgres issues list, importing and exporting statistics, more Postgres 18 beta fe...
Here Comes Async I/O! | Scaling Postgres 365
11 May 2025
Contributed by Lukas
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 ...
Scaling For High Volume | Scaling Postgres 364
04 May 2025
Contributed by Lukas
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 p...
Top Ten Postgres Dos & Don'ts | Scaling Postgres 363
27 Apr 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss a top ten dos and don't for Postgres, understanding statistics and extended statistics, aligning colum...
Optimizing For Time-Series Data | Scaling Postgres 362
20 Apr 2025
Contributed by Lukas
In this episode, we discuss optimizing for time-series data, indexing vectors, Postgres APT extension packaging and how to optimize queries involving ...
A Roadmap To Scaling Postgres | Scaling Postgres 361
13 Apr 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss a roadmap to scaling Postgres, life altering Postgres patterns, making Postgres better with OrioleDB, ...
Handle One Million Connections? | Scaling Postgres 360
06 Apr 2025
Contributed by Lukas
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 pgvec...
Trillions of Rows & Metrics | Scaling Postgres 359
30 Mar 2025
Contributed by Lukas
In this episode of Scaling Postgres, we talk about indexes being added to Timescale's column store, processing 1 trillion metrics in Timescale, proces...
Postgres Conference 2025 | Scaling Postgres 358
23 Mar 2025
Contributed by Lukas
In this episode of Scaling Postgres, I discuss my experience attending Postgres Conference 2025 and cover some of the highlights of the conference. In...
Postgres Best Practices? | Scaling Postgres 357
16 Mar 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss best practices, caching monitoring statistics, a new vector extension called VectorChord and the impor...
Is the Future Immutable? | Scaling Postgres 356
09 Mar 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss immutability and Postgres, the upcoming Postgres Conference in Orlando, extended statistics and usage ...
Top Ten Analytics with pg_mooncake | Scaling Postgres 355
02 Mar 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss how Postgres & pg_mooncake achieves top ten Clickbench results, a comparison of Oracle and Postgre...
Postgres & The US Treasury Attack | Scaling Postgres 354
23 Feb 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss the role of Postgres in the US Treasury online attack, new releases of Postgres, optimizing applicatio...
OLTP To Parquet For Analytics | Scaling Postgres 353
16 Feb 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss how data can flow from your OLTP to parquet files for analytics, parallel queries, view inlining and p...
You Can Always Optimize More | Scaling Postgres 352
09 Feb 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss how you can always optimize more, avoiding deadlocks, casting & indexes and pg_hint_plan best prac...
Features To Avoid? | Scaling Postgres 351
02 Feb 2025
Contributed by Lukas
In this episode of Scaling Postgres, we talk about some features you may want to avoid like commit_delay, index_cleanup off, & logon triggers, a w...
Seven Years of Scaling Postgres | Scaling Postgres 350
26 Jan 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss our seven year anniversary, better pg_search performance, reducing table locks, not valid constraints ...
The Dangers of Temporary Tables | Scaling Postgres 349
19 Jan 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss the dangers of temporary tables, better transparent data encryption, pig the extension wizard, and tab...
The Future Is Containers? | Scaling Postgres 348
12 Jan 2025
Contributed by Lukas
In this episode of Scaling Postgres, we discuss whether the future of containers and Postgres, UUIDv7 commit, and a pg_duckdb interview. To get the sh...
Easy Incremental Data Processing? | Scaling Postgres 347
22 Dec 2024
Contributed by Lukas
In this episode of Scaling Postgres, we discuss the new pg_incremental extension for processing data pipelines, a set of Postgres monitoring queries, ...
Things I Don't Do In Postgres | Scaling Postgres 346
15 Dec 2024
Contributed by Lukas
In this episode of Scaling Postgres, we discuss things I do not do such as use default partitions, play column Tetris, ELT using special data types or...
Over 5X Faster Postgres? | Scaling Postgres 345
08 Dec 2024
Contributed by Lukas
In this episode of Scaling Postgres, we discuss OrioleDB getting Postgres over 5 times faster, historical OLAP performance, efficient queries and whet...
Performance & Hard Things | Scaling Postgres 344
01 Dec 2024
Contributed by Lukas
In this episode of Scaling Postgres, we discuss new releases, collation speed, ZFS performance, insert benchmarking and pglz vs. lz4 performance. To g...
Postgres Release Warning! | Scaling Postgres 343
24 Nov 2024
Contributed by Lukas
In this episode of Scaling Postgres, we discuss new Postgres releases and an out-of-band release to address issues, increasing insert performance by 2...
Faster Writes With ZFS? | Scaling Postgres 342
17 Nov 2024
Contributed by Lukas
In this episode of Scaling Postgres, we discuss the read and write performance of Postgres on ZFS, handling URL text identifiers in the database, deno...
The Future of Postgres Upgrades | Scaling Postgres 341
10 Nov 2024
Contributed by Lukas
In this episode of Scaling Postgres, we discuss the future of Postgres upgrades, the usefulness of pg_dump, partitioning with minimal downtime and lim...
Do You Need A Vectorizer? | Scaling Postgres 340
03 Nov 2024
Contributed by Lukas
In this episode of Scaling Postgres, we discuss whether you need a vectorizer, different ways to bin or bucket timestamps, addressing a bad plan and a...
Postgres Goes Parquet | Scaling Postgres 339
27 Oct 2024
Contributed by Lukas
In this episode of Scaling Postgres, we discuss pg_parquet allowing Postgres to read and write parquet files, other useful extensions, open source bou...
JSON Goodies In Postgres 17 | Scaling Postgres 338
20 Oct 2024
Contributed by Lukas
In this episode of Scaling Postgres, we discuss the JSON goodies in Postgres 17, trigger recursion, pg_dump as backup and pg_timeseries columnar perfo...
77 Times Faster In Postgres 17 | Scaling Postgres 337
13 Oct 2024
Contributed by Lukas
In this episode of Scaling Postgres, we discuss how one query runs 77 times faster in Postgres 17, a detailed Postgres 17 performance webinar, using l...
More Postgres 17 Highlights | Scaling Postgres 336
06 Oct 2024
Contributed by Lukas
In this episode of Scaling Postgres, we discuss more about the features released with Postgres 17, an example of performance improvements, things to w...
Postgres 17 Released! | Scaling Postgres 335
29 Sep 2024
Contributed by Lukas
In this episode of Scaling Postgres, we discuss the release of Postgres 17, b-tree performance gains, logical replication enhancements and different l...
Optimizing For Analytics | Scaling Postgres 334
22 Sep 2024
Contributed by Lukas
In this episode of Scaling Postgres, we discuss how to optimize your database for analytics, how to speed up counts, improvements to TimescaleDB and w...
When Select Writes! | Scaling Postgres 333
15 Sep 2024
Contributed by Lukas
In this episode of Scaling Postgres, we discuss when select can write, Postgres RC1 is released, Tetris in SQL and copy, swap, drop. To get the show n...
Sometimes It Is Slow? | Scaling Postgres 332
08 Sep 2024
Contributed by Lukas
In this episode of Scaling Postgres, we discuss what can happen when queries get slow, backup best practices, Postgres emergencies and the state of Po...
Is pg_dump A Backup Tool? | Scaling Postgres 331
01 Sep 2024
Contributed by Lukas
In this episode of Scaling Postgres, we discuss whether pg_dump is a backup tool, the pgMonitor extension, Postgres malware, and application uses for ...
Splicing Elephant & Duck DNA | Scaling Postgres 330
25 Aug 2024
Contributed by Lukas
In this episode of Scaling Postgres, we discuss the merging of Postgres and DuckDB via the pg_duckdb extension, how this can help the analytics story ...
PGlite: Embeddable Postgres & postgres.new | Scaling Postgres 329
18 Aug 2024
Contributed by Lukas
In this episode of Scaling Postgres, we discuss PGlite, an embeddable Postgres, postgres.new which adds AI features, new Postgres releases and the per...
Implement Get Or Create | Scaling Postgres 328
11 Aug 2024
Contributed by Lukas
In this episode of Scaling Postgres, we discuss different get or create implementations, a new pgBouncer version, alter default privileges, and six de...
Postgres Graph Queries | Scaling Postgres 327
04 Aug 2024
Contributed by Lukas
In this episode of Scaling Postgres, we discuss using Postgres for graph queries, the fastest way to copy data from one table to another, dealing with...
Faster Index Creation | Scaling Postgres 326
28 Jul 2024
Contributed by Lukas
In this episode of Scaling Postgres, we talk about speeding up index creation, extensions to track wait events, a row pattern recognition feature and ...
Faster Paging? | Scaling Postgres 325
21 Jul 2024
Contributed by Lukas
In this episode of Scaling Postgres, we discuss more ways to keep the superior performance of keyset pagination, how to implement UUIDv7 in SQL functi...
Four Million TPS | Scaling Postgres 324
14 Jul 2024
Contributed by Lukas
In this episode of Scaling Postgres, we discuss experiments to achieve four million transaction per second, the importance of extended statistics, par...
PgBouncer Breaking Change | Scaling Postgres 323
07 Jul 2024
Contributed by Lukas
In this episode of Scaling Postgres, we discuss a breaking change in the new version of PgBouncer, PostgreSQL 17 Beta 2 is released, examination of th...
Postgres Sort Instability? | Scaling Postgres 322
30 Jun 2024
Contributed by Lukas
In this episode of Scaling Postgres, we discuss an incremental sort instability issue with the Postgres planner, whether we should use foreign keys, h...
Ottertune Is Dead! | Scaling Postgres 321
23 Jun 2024
Contributed by Lukas
In this episode of Scaling Postgres, we discuss the shutdown of Ottertune, how schema changes cause locks and how to avoid them, the benefits of on co...
100 TB and Beyond! | Scaling Postgres 320
16 Jun 2024
Contributed by Lukas
In this episode of Scaling Postgres, we discuss three organizations scaling their databases to 100 TB and beyond, collation speed, configuring memory ...
When Postgres Development Stopped! | Scaling Postgres 319
09 Jun 2024
Contributed by Lukas
In this episode of Scaling Postgres, we discuss a time when Postgres development stopped, two new extensions pg_lakehouse & pg_compare and the upc...
Postgres 17 Beta 1 Released | Scaling Postgres 318
02 Jun 2024
Contributed by Lukas
In this episode of Scaling Postgres, we discuss all the new features in Postgres 17 Beta 1, some features that did not make it, database collations &a...
Time-Series Open Source Extension | Scaling Postgres 317
26 May 2024
Contributed by Lukas
In this episode of Scaling Postgres, we discuss a new time-series open source extension called pg_timeseries, Postgres ignoring indexes, JSONB selecti...
New Releases & 1,000 Times Faster Query | Scaling Postgres 316
19 May 2024
Contributed by Lukas
In this episode of Scaling Postgres, we discuss new Postgres releases, optimizing a query to be 1,000 times faster, custom vs. generic plans and the p...
Hacking On Postgres is Hard! | Scaling Postgres 315
12 May 2024
Contributed by Lukas
In this episode of Scaling Postgres, we discuss how hacking on Postgres is hard, a notifier pattern for using Listen/Notify, using histograms for metr...
150 Times Faster pgvector? | Scaling Postgres 314
05 May 2024
Contributed by Lukas
In this episode of Scaling Postgres, we discuss performance improvements for pgvector 0.7.0, a guide to vector embeddings, building a Retrieval Augmen...
The Future of MySQL is Postgres? | Scaling Postgres 313
28 Apr 2024
Contributed by Lukas
In this episode of Scaling Postgres, we discuss whether the future of MySQL is Postgres, how to use recursive CTEs, work on OrioleDB, and PG17 perform...