Latest Episodes
402
Millions 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...
401
One 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...
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...