Scaling Postgres

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. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.percona.com/blog/2019/11/20/proposal-for-global-indexes-in-postgresql/ https://evilmartians.com/chronicles/pulling-the-trigger-how-to-update-counter-caches-in-you-rails-app-without-active-record-callbacks https://severalnines.com/database-blog/overview-vacuum-processing-postgresql https://www.cybertec-postgresql.com/en/effective_cache_size-what-it-means-in-postgresql/ https://www.youtube.com/channel/UCLjZee4-RXhkOxz-p-h5hBg/videos https://rafiasabih.blogspot.com/2019/11/which-size-fits-me.html https://hakibenita.com/sql-dos-and-donts https://pganalyze.com/blog/similarity-in-postgres-and-ruby-on-rails-using-trigrams https://info.crunchydata.com/blog/enhancing-your-postgresql-12-security-with-the-cis-benchmark https://severalnines.com/d