Scaling Postgres

In this episode of Scaling Postgres, we review articles covering checking on vacuum, how to get a fast distinct count and speed up group by and a health check playbook. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://medium.com/gett-engineering/scaling-postgresql-check-your-vacuum-f03092a6399e https://www.peterbe.com/plog/best-way-to-count-distinct-indexed-things-in-postgresql https://www.cybertec-postgresql.com/en/speeding-up-group-by-in-postgresql/ https://www.citusdata.com/blog/2019/03/29/health-checks-for-your-postgres-database/ https://habr.com/en/company/postgrespro/blog/443284/ https://www.depesz.com/2019/03/29/waiting-for-postgresql-12-reindex-concurrently/ http://www.postgis.us/presentations/PGConf2019_data_loading.pdf https://blog.2ndquadrant.com/need-root-crt-file/ http://blog.cleverelephant.ca/2019/03/geojson.html https://postgresql.verite.pro/blog/2019/03/28/tsearch-dictionary.html https://pgstef.github.io/2019/03/26/pgbackrest_