In this episode of Scaling Postgres, we discuss the "Ballad of Bloat", options for auditing, a configuration help resource and determining when a vacuum is needed.
Subscribe at https://www.scalingpostgres.com to get notified of new episodes.
Links for this episode:
https://www.youtube.com/watch?v=2NxIngqq1y0
https://www.cybertec-postgresql.com/en/row-change-auditing-options-for-postgresql/
https://www.ongres.com/blog/postgresqlconf-configuration-for-humans/
https://postgresqlco.nf/en/doc/param/
https://richyen.com/postgres/2020/01/29/underestimating_log.html
https://www.depesz.com/2020/01/29/which-tables-should-be-auto-vacuumed-or-auto-analyzed/
https://www.depesz.com/2020/01/28/dont-do-these-things-in-postgresql/
https://pgdash.io/blog/pgctl-tips-tricks.html
https://www.credativ.com/blog/debian-integration-patroni-and-vip-manager
https://info.crunchydata.com/blog/schedule-postgresql-backups-and-retention-with-kubernetes
https://info.crunchydata.com/blog/migrating-from-oracle-to-postgresql-questions-and-considerations
https://www.2ndquadrant.com/en/blog/barman-cloud-part-1-wal-archive/
https://www.cybertec-postgresql.com/en/pg_timetable-advanced-postgresql-job-scheduling/
https://www.highgo.ca/2020/01/28/understanding-prepared-transactions-and-handling-the-orphans/
https://www.2ndquadrant.com/en/blog/developing-postgresql-windows-part-1/