
Scaling Postgres Episode 91 Global Indexes | Caching Aggregates | Vacuum Processing | Effective Cache Size
Get New Episodes Weekly!
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