Latest Episodes
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,...
394
5 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...