In this episode of Scaling Postgres, we review articles covering petabyte scale techniques as well as various articles on locking.
Head on over to https://www.scalingpostgres.com to get notified of new episodes.
Links for this episode:
- https://www.scalingpostgres.com/episodes/1-petabyte-scale-and-locking
- https://heapanalytics.com/blog/engineering/testing-database-changes-right-way
- https://www.slideshare.net/ChrisTravers5/postgresql-at-20tb-and-beyond
- https://blog.rustprooflabs.com/2018/02/pg10_parallel_queries
- https://www.citusdata.com/blog/2018/02/15/when-postgresql-blocks/
- https://www.citusdata.com/blog/2018/02/22/seven-tips-for-dealing-with-postgres-locks/
- https://blog.fin.com/migrations-and-long-transactions-in-postgres-e6c3fbae56a5
- https://pgstef.github.io/2018/02/07/introduction_to_postgresql_automatic_failover.html
- https://blog.2ndquadrant.com/postgresql-maximum-table-size/