DevOps - Postgres - config and migrations
Awesome example of RDBMS HW upgrade
https://tech.coffeemeetsbagel.com/our-journey-to-postgresql-12-3d6ee15d305a
Postgres scaling advice
https://www.cybertec-postgresql.com/en/postgres-scaling-advice-for-2021/
Logical replication
https://www.cybertec-postgresql.com/en/upgrading-postgres-major-versions-using-logical-replication/
Notes on scalability
https://github.com/hwayne/awesome-cold-showers#scalability-but-at-what-cost
Single DB at a large company
https://unstructed.tech/2021/01/11/your-legacy-database-is-outgrowing-itself/
DB management
- inspecting usefulness of indexes
- cleaning up, reducing storage https://hakibenita.com/postgresql-unused-index-size
securing database access
- network layer
- transport layer
- roles and permissions
- row-level access https://goteleport.com/blog/securing-postgres-postgresql/
Zero-downtime migrations
http://www.braintreepayments.com/blog/switching-datacenters/
Zero-downtime migrations
- COMPLEX APPROACH https://engineering.theblueground.com/blog/zero-downtime-postgres-migration-done-right/