---
title: "Discussion on \"Postgres attach partition deadlocks\" | Hashnode"
description: "Discussion on \"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.\nPossible approaches\nLets start the db with:\n docker run..."
url: "https://hashnode.com/posts/postgres-attach-partition-deadlocks/67f4470b939c4583e2c113e8"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Postgres attach partition deadlocks](https://piotrd.hashnode.dev/postgres-attach-partition-deadlocks?utm_source=hashnode&utm_medium=feed)

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...

Apr 7, 2025 · 6 min read · piotrd.hashnode.dev  
Read the article

-   [#postgresql](https://hashnode.com/tag/postgresql)
-   [#database-partitioning](https://hashnode.com/tag/database-partitioning)

## Written by

[Piotr](https://hashnode.com/@PiDu)

@PiDu · Poland, Warsaw

  
[View profile](https://hashnode.com/@PiDu)

Passionate tech lover and Java developer

I have a background in Aerospace Engineering. My professional experience spans from shooting hypersonic rockets as a member of Student's Space associacion, through designing 3d models of parts for Aeroderived Gas Turbines and finally to working as an Space Surveillance Engineer. For past years I have been working as a Java developer and loved how powerful tool can it be.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.