Health check

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 …

databases postgres postgresql sql technology