**Find the article on our blog here:**
https://pganalyze.com/blog/5mins-postgres-migrations-avoid-deadlocks

In E93 of “5mins of Postgres”, we're talking about how to avoid deadlocks in Postgres migrations and surprising lock behavior with migrations that I personally encountered.

**Learn more about pganalyze:**
https://pganalyze.com
https://pganalyze.com/newsletter
https://twitter.com/pganalyze/

**Check out the pganalyze library for eBooks, webinars, and more:**
https://pganalyze.com/resources

📑 *What we have discussed in this episode of 5mins of Postgres:*

**How to avoid deadlocks in PostgreSQL migrations - by Vanessa Ung**
https://medium.com/dovetail-engineering/writing-safe-database-migrations-4b19d48029e9

**5mins of Postgres E28: Row Level Security in Postgres, security invoker views and why LEAKPROOF functions matter**
https://pganalyze.com/blog/5mins-postgres-row-level-security-bypassrls-security-invoker-views-leakproof-functions

**Strong Migrations - GitHub Repo by Andrew Kane**
https://github.com/ankane/strong_migrations

**idle_in_transaction_session_timeout - postgresql.org**
https://www.postgresql.org/docs/16/runtime-config-client.html#GUC-IDLE-IN-TRANSACTION-SESSION-TIMEOUT