In this episode of Scaling Postgres, we discuss scaling advice, a vicious cycle of WAL writes, how to improve observability and addressing database corruption.

Subscribe at https://www.scalingpostgres.com to get notified of new episodes.

Links for this episode:

https://www.cybertec-postgresql.com/en/postgres-scaling-advice-for-2021/

https://mydbanotebook.org/post/vicious-circle/

https://pgdash.io/blog/postgres-observability.html

https://www.highgo.ca/2021/01/27/avoiding-identifying-and-dealing-with-postgresql-database-corruption-part-1/

https://tech.coffeemeetsbagel.com/our-journey-to-postgresql-12-3d6ee15d305a

https://www.cybertec-postgresql.com/en/monitoring-replication-pg_stat_replication/

https://www.depesz.com/2021/01/28/how-to-run-some-tasks-without-user-intervention-at-specific-times-part-2/

https://www.youtube.com/watch?v=ndtN6vYhyUU

https://www.percona.com/blog/2021/01/28/how-to-create-postgresql-custom-builds-and-debian-packages/

https://www.highgo.ca/2021/01/25/a-preliminary-exploration-of-dynamic-hashing-in-postgresql/

https://info.crunchydata.com/blog/set-up-tls-for-postgresql-in-kubernetes

https://info.crunchydata.com/blog/deploy-tls-for-pgbouncer-in-kubernetes

https://elephanttamer.net/?p=55

https://blog.rustprooflabs.com/2021/01/pgosm-flex-improved-openstreetmap-places-postgis

https://postgresql.life/post/franck_pachot/