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