Scaling Postgres Episode 194 Go Faster | GIN Indexes | Collation Stability | PG14 & Beyond

In this episode of Scaling Postgres, we discuss going slower to go faster, GIN indexes, collation stability and features of PG14 and beyond.

Content Discussed

• Slow things down to make them go faster [Postgres Build 2021]
• Understanding Postgres GIN Indexes: The Good and the Bad
• Collation Stability
• PostgreSQL 14 and beyond
• PostgreSQL vs Python for data cleaning: A guide
• Primary Keys vs. UNIQUE Constraints in PostgreSQL
• PostgreSQL 14 Database Monitoring and Logging Enhancements
• Transition Tables in Incremental View Maintenance (Part II): Multliple Tables Modification case
• PostGIS Day 2021
• Tricks for Faster Spatial Indexes
• Permissions required for PostGIS
• Fabien Coelho