Latest Episodes
327
Postgres Graph Queries | Scaling Postgres 327
In this episode of Scaling Postgres, we discuss using Postgres for graph queries, the fastest way to copy data from one table to another,...
326
Faster Index Creation | Scaling Postgres 326
In this episode of Scaling Postgres, we talk about speeding up index creation, extensions to track wait events, a row pattern recognition feature and...
325
Faster Paging? | Scaling Postgres 325
In this episode of Scaling Postgres, we discuss more ways to keep the superior performance of keyset pagination, how to implement UUIDv7 in SQL...
324
Four Million TPS | Scaling Postgres 324
In this episode of Scaling Postgres, we discuss experiments to achieve four million transaction per second, the importance of extended statistics, parallelism in Postgres...
323
PgBouncer Breaking Change | Scaling Postgres 323
In this episode of Scaling Postgres, we discuss a breaking change in the new version of PgBouncer, PostgreSQL 17 Beta 2 is released, examination...
322
Postgres Sort Instability? | Scaling Postgres 322
In this episode of Scaling Postgres, we discuss an incremental sort instability issue with the Postgres planner, whether we should use foreign keys, how...