Latest Episodes
307
Collation Conundrum | Scaling Postgres 307
In this episode of Scaling Postgres, we discuss whether we should be using bytewise or linguistic ordering by default, how to transform data in...
306
Scalability Limits From SLRU & Lock Manager | Scaling Postgres 306
In this episode of Scaling Postgres, we discuss one configuration change that resulted in an 11,000 times faster query, why Postgres is not using...
305
11K Faster Configuration Change | Scaling Postgres 305
In this episode of Scaling Postgres, we discuss one configuration change that resulted in an 11,000 times faster query, why Postgres is not using...
304
Overhead of pg_stat_statements | Scaling Postgres 304
In this episode of Scaling Postgres, we discuss new Postgres releases, performance comparisons between PgBouncer, PgCat and Supavisor, a new extension pg_analytics, and new...
303
PgBouncer, PgCat, Supavisor Fight!!! | Scaling Postgres 303
In this episode of Scaling Postgres, we discuss new Postgres releases, performance comparisons between PgBouncer, PgCat and Supavisor, a new extension pg_analytics, and new...
302
UUID vs Bigint Battle!!! | Scaling Postgres 302
In this episode of Scaling Postgres, we discuss when and how you should use UUIDs or not, how to optimize space with column order...