Nikolay and Michael discuss Postgres health checks — what they are, things to include, how often makes sense, and whether improvements to Postgres would increase or decrease the need for them.
Here are some links to things they mentioned:
- MOT (car test in the UK) https://en.wikipedia.org/wiki/MOT_test
- Let's make PostgreSQL multi-threaded (discussion started by Heikki) https://www.postgresql.org/message-id/flat/31cc6df9-53fe-3cd9-af5b-ac0d801163f4%40iki.fi
- postgres-checkup https://gitlab.com/postgres-ai/postgres-checkup
- Why upgrade https://why-upgrade.depesz.com/
- Related episodes:
- Default configuration https://postgres.fm/episodes/default-configuration
- Index maintenance https://postgres.fm/episodes/index-maintenance
- Bloat https://postgres.fm/episodes/bloat
- Monitoring checklist https://postgres.fm/episodes/monitoring-checklist
- pg_stat_statements https://postgres.fm/episodes/pg_stat_statements
- Backups https://postgres.fm/episodes/backups
~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!
~~~
Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai
- Michael Christofides, founder of pgMustard
With special thanks to:
- Jessie Draws for the amazing artwork