Episode 89
Health check
Postgres FM · Nikolay Samokhvalov and Michael Christofides
March 22, 202440m 49s
Audio is streamed directly from the publisher (media.transistor.fm) as published in their RSS feed. Play Podcasts does not host this file. Rights-holders can request removal through the copyright & takedown page.
Show Notes
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
Topics
PostgresPostgreSQLDatabasesSQLtechnology