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
• 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
• Braces Are Too Expensive

YouTube Video