Postgres attach partition deadlocks

It is quite easy in busy database to cause deadlocks when dynamically attaching partitions, or hold the locks for too long. Let’s see why this occurs and how to attach partitions in optimal way. Possible approaches Lets start the db with: docker run...