![Zero-downtime Postgres schema migrations need this: lock_timeout and retries | Database branching for any Postgres DB · Postgres.ai · DBLab Zero-downtime Postgres schema migrations need this: lock_timeout and retries | Database branching for any Postgres DB · Postgres.ai · DBLab](https://postgres.ai/assets/blog/20210923/lock-conflicts-table.png?2)
Zero-downtime Postgres schema migrations need this: lock_timeout and retries | Database branching for any Postgres DB · Postgres.ai · DBLab
Hussein Nasser on LinkedIn: I used to think database locks are two types, shared and exclusive. I was… | 13 comments
![Useful queries to analyze PostgreSQL lock trees (a.k.a. lock queues) | Database branching for any Postgres DB · Postgres.ai · DBLab Useful queries to analyze PostgreSQL lock trees (a.k.a. lock queues) | Database branching for any Postgres DB · Postgres.ai · DBLab](https://postgres.ai/assets/thumbnails/postgresql-query-for-lock-trees-analysis-2.png)