Podcast Episodes

Adopting PgCat, Time Bins, work_mem Settings, Bad Constraints | Scaling Postgres 257

Episode 257

In this episode of Scaling Postgres, we discuss Instacart adopting PgCat, binning or bucketing your data by time, the best settings for work_mem and how to avoid bad check constraints.

To get the sho…

Published on 2 years, 9 months ago

11TB WAL, pgec Writes, Patroni 3 & Citus, PostgREST | Scaling Postgres 256

Episode 256

In this episode of Scaling Postgres, we discuss WAL growing to 11 Terabytes, pgec supporting writes, Patroni 3.0 & Citus for high availability, and setting up PostgREST.

To get the show notes as well…

Published on 2 years, 9 months ago

Integer Overflow, User-Friendly Permissions, Dump & Logical Replication, Worker Config | Scaling Postgres 255

Episode 255

In this episode of Scaling Postgres, we discuss how to detect & handle integer overflows, a wish for user-friendly permissions, using a dump to start logical replication and configuring background wo…

Published on 2 years, 9 months ago

PG Edge Cache, Postgres & OpenAI, citext to Collations, Compression Options | Scaling Postgres 254

Episode 254

In this episode of Scaling Postgres, we discuss PG Edge Cache, using Postgres & OpenAI, migrating citext to case-insenstive collations and PG16 compression options.

To get the show notes as well as g…

Published on 2 years, 9 months ago

Unlogged Tables, pg_stat_io, Type Constraints, Text Types | Scaling Postgres 253

Episode 253

In this episode of Scaling Postgres, we discuss working with unlogged tables, the new pg_stat_io feature, handling complex type constraints and choosing the best text type.

To get the show notes as w…

Published on 2 years, 10 months ago

Postgres Releases, Performance Secrets, Don't Do This, Filter vs. Case | Scaling Postgres 252

Episode 252

In this episode of Scaling Postgres, we discuss new Postgres releases, performance secrets, things not to do and filter vs. case.

To get the show notes as well as get notified of new episodes, visit:…

Published on 2 years, 10 months ago

Filter Clause, Hypothetical Index, Non-Relational Data, Using TOAST | Scaling Postgres 251

Episode 251

In this episode of Scaling Postgres, we discuss how to use the filter clause, create hypothetical indexes, store non-relational data and manage TOAST.

To get the show notes as well as get notified of…

Published on 2 years, 10 months ago

Performance Issue, Survive Without Superuser, Reserved Connections, Partition Management | Scaling Postgres 250

Episode 250

In this episode of Scaling Postgres, we discuss resolving a performance issue, how PG16 allows you to survive without a superuser, reserving connections and handling partition management.

To get the …

Published on 2 years, 10 months ago

Locking Tables, Foreign Key Issue, Slow Decimals, Memoize & Joins | Scaling Postgres 249

Episode 249

In this episode of Scaling Postgres, we discuss issues with locking tables, foreign keys and slow decimals. We also cover when joins use memoize.

To get the show notes as well as get notified of new …

Published on 2 years, 10 months ago

Pagination Solutions, Return Modifications, Insert Deletions, How To JSON | Scaling Postgres 248

Episode 248

In this episode of Scaling Postgres, we discuss different pagination solutions, how to return modifications, soft deletion alternatives and how to use JSON with PostgreSQL.

To get the show notes as w…

Published on 2 years, 11 months ago