Checking Vacuum, Fast Distinct Count, Group By Speed Up, Health Check | Scaling Postgres 57
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_archiving_tricks.html
Create your
podcast in
minutes
It is Free