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.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/91-global-indexes-caching-aggregates-vacuum-processing-effective-cache-size/