Episodes on how best to scale your PostgreSQL relational database.
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 resolve to slow order by limit queries.
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 sharded databases and a blue/green rollback.
In this episode of Scaling Postgres, we discuss DocumentDB moving to the Linux Foundation, multi-column indexes, SCRAM pass-through and RDS Proxy oddities.
In this episode of Scaling Postgres, we discuss enhancements to Oriole DB, new Postgres releases, a logging guide and application framework frustrations.
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 recommendations when doing performance optimizations.
In this episode of Scaling Postgres, we discuss Postgres getting a native column store via an index, faster btree_gift indexes, scaling listen/notify, and a logical replication slot deep dive.
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 enough text searching performance.
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 space overrun and struggles starting Postgres.
In this episode of Scaling Postgres, we discuss new benchmarks as a result of the Planetscale Postgres announcement, various platform improvements and a deep dive into Multigres.
In this episode of Scaling Postgres, we discuss how Jira migrated millions of databases, when sigterm does nothing, should you ditch vector search and mastering replication slots.
