Latest Episodes
405
Out 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...
404
Postmaster 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...
403
Mitigate 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...
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...