- Zero-downtime Postgres schema migrations need this: lock_timeout and retries https://postgres.ai/blog/20210923-zero-downtime-postgres-schema-migrations-lock-timeout-and-retries 3 comments postgresql
Linking pages
- Common DB schema change mistakes | Postgres.AI https://postgres.ai/blog/20220525-common-db-schema-change-mistakes 83 comments
- PgBouncer is useful, important, and fraught with peril - JP Camara https://jpcamara.com/2023/04/12/pgbouncer-is-useful.html 83 comments
- Useful queries to analyze PostgreSQL lock trees (a.k.a. lock queues) | Database branching for any Postgres DB · Postgres.ai · Database Lab Engine (DLE) https://postgres.ai/blog/20211018-postgresql-lock-trees 1 comment
Linked pages
- PostgreSQL Subtransactions Considered Harmful | Database Lab · Instant clones of PostgreSQL databases · Postgres.ai https://postgres.ai/blog/20210831-postgresql-subtransactions-considered-harmful 41 comments
- Exponential Backoff And Jitter | AWS Architecture Blog https://aws.amazon.com/blogs/architecture/exponential-backoff-and-jitter/ 15 comments
- PostgreSQL: Documentation: 15: 28.2. The Cumulative Statistics System https://www.postgresql.org/docs/current/monitoring-stats.html#MONITORING-PG-STATIO-ALL-TABLES-VIEW 8 comments
- I know that I know nothing - Wikipedia https://en.wikipedia.org/wiki/I_know_that_I_know_nothing 6 comments
- Exponential backoff - Wikipedia http://en.wikipedia.org/wiki/Exponential_backoff 0 comments