Scaling Postgres Episode 86 Prewarming | Nondeterministic Collations | Generated Column Performance | Foreign Keys

In this episode of Scaling Postgres, we discuss prewarming your cache, working with nondeterministic collations, generated column performance and foreign keys with partitions.

Content Discussed

Prewarming PostgreSQL I/O caches
Nondeterministic collations
Regenerated
PostgreSQL 12: Foreign Keys and Partitioned Tables
Postgres-BDR: It is also about fast safe upgrades
Managing another PostgreSQL Commitfest
Braces Are Too Expensive
Tuning checkpoints
PgBouncer 1.12.0
PostgreSQL Connection Pooling: Part 1 — Pros & Cons
PostGIS 3.0.0rc2
Generating land-constrained geographical point grids with PostGIS