Latest Episodes
400
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...
399
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...
398
Latency 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...
397
Vacuum 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...
396
600 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...
395
16 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,...