Avoiding deadlocks in Postgres migrations

*Find the article on our blog here:*
https://pganalyze.com/blog/5mins-post...

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
  / 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*
  / writing-safe-database-migrations  

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

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

*idle_in_transaction_session_timeout - postgresql.org*
https://www.postgresql.org/docs/16/ru...