Scaling Postgres Episode 91 Global Indexes | Caching Aggregates | Vacuum Processing | Effective Cache Size

In this episode of Scaling Postgres, we discuss global indexes, ways to cache aggregates, how vacuum processing works and the purpose of effective cache size.

Content Discussed

• Proposal for Global Indexes in PostgreSQL
• Pulling the trigger: How to update counter caches in your Rails app without Active Record callbacks
• An Overview of VACUUM Processing in PostgreSQL
• effective_cache_size: What it means in PostgreSQL
• [YouTube] PostgresConf South Africa Channel
• Which size fits me?
• 12 Common Mistakes and Missed Optimization Opportunities in SQL
• Similarity in Postgres and Rails using Trigrams
• Enhancing PostgreSQL 12 Security with the CIS Benchmark
• PostgreSQL Deployment & Configuration with Puppet
• OGR FDW Spatial Filtering

YouTube Video