Scaling Postgres Episodes Page 5

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 planner capabilities in PG16.

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 and arrays, whether it is better to tune parameters or queries and what devs should know about Postgres with Andrew Atkinson.

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

In this episode of Scaling Postgres, we discuss a LLM OS dedicated to Postgres knowledge, 30 times faster index builds for HNSW indexes, a pgbouncer release and an interview with Michael Christofides.

Scaling Postgres Celebration | Scaling Postgres 300

In this episode of Scaling Postgres, we look back over 300 episodes, discuss a way to find locking processes, review disadvantages of cloud hosted solutions, and how to partition with UUIDv7.

Build A GPT In SQL | Scaling Postgres 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 columns.

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

In this episode of Scaling Postgres, we discuss how distributed Postgres solutions can result in 10-100 times higher latency, building incremental backup, DBMS of the Year and understanding explain.

Postgres In 2024 | Scaling Postgres 297

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.

State Of Postgres 2023 | Scaling Postgres 296

In this episode of Scaling Postgres, we discuss the State of Postgres 2023 survey, a repository of Postgres how-tos, ways foreign keys can break and a custom SQL playground.

30K Messages Per Second Queue | Scaling Postgres 295

In this episode of Scaling Postgres, we discuss a 30K messages per second queue built on Postgres, a zero downtime logical replication upgrade, the release of the Supavisor 1.0 connection pooler and PostGIS day.

How Much Observability Is Needed? | Scaling Postgres 294

In this episode of Scaling Postgres, we discuss how much observability is needed, avoiding locks during database migrations, a huge Postgres events blogging event and FIPS mode.