Podcast Episodes

Collation Conundrum | Scaling Postgres 307

Episode 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 Postgres, benefits of a transaction_timeout and how to …

Published on 1 year, 9 months ago

Scalability Limits From SLRU & Lock Manager | Scaling Postgres 306

Episode 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 your index, backported PG improvements and parallelis…

Published on 1 year, 9 months ago

11K Faster Configuration Change | Scaling Postgres 305

Episode 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 your index, backported PG improvements and parallelis…

Published on 1 year, 9 months ago

Overhead of pg_stat_statements | Scaling Postgres 304

Episode 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 planner capabilities in PG…

Published on 1 year, 9 months ago

PgBouncer, PgCat, Supavisor Fight!!! | Scaling Postgres 303

Episode 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 planner capabilities in PG…

Published on 1 year, 10 months ago

UUID vs Bigint Battle!!! | Scaling Postgres 302

Episode 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 and arrays, whether it is better to tune parameters or queries and wh…

Published on 1 year, 10 months ago

Postgres LLM OS & 30 Times Faster Index Builds | Scaling Postgres 301

Episode 301

In this episode of Scaling Postgres, we discuss how you can build a GPT in 500 lines of SQL code, how to optimize extension loading, the best way to set passwords and being able to change generated c…

Published on 1 year, 10 months ago

Scaling Postgres Celebration | Scaling Postgres 300

Episode 300

In this episode of Scaling Postgres, we discuss how you can build a GPT in 500 lines of SQL code, how to optimize extension loading, the best way to set passwords and being able to change generated c…

Published on 1 year, 10 months ago

Build A GPT In SQL | Scaling Postgres 299

Episode 299

In this episode of Scaling Postgres, we discuss how you can build a GPT in 500 lines of SQL code, how to optimize extension loading, the best way to set passwords and being able to change generated c…

Published on 1 year, 11 months ago

10-100 Times Higher Latency With Distributed Postgres | Scaling Postgres 298

Episode 298

In this episode of Scaling Postgres, we discuss hopes for Postgres in 2024, whether you need foreign keys, incremental backups, and five ways of doing not exists.

To get the show notes as well as get…

Published on 1 year, 11 months ago