Postgres Pro
Downloads
Home   >   mailing lists

Re: Undetected Deadlock - Mailing list pgsql-general

From Michael Lewis
Subject Re: Undetected Deadlock
Date
Msg-id CAHOFxGr_KbbBCeU9RtDPwszqbci0NEtT+Uo3RM5k=N9TQSSsGg@mail.gmail.com
Whole thread Raw
In response to Re: Undetected Deadlock  (Michael Harris <harmic@gmail.com>)
Responses Re: Undetected Deadlock
List pgsql-general
Tree view
I must be missing something. You mentioned dropping a partition, so is there an actual need for the delete? Could you detach concurrently and then drop the table or delete rows if needed?

https://www.postgresql.org/docs/14/sql-altertable.html#SQL-ALTERTABLE-DETACH-PARTITION

pgsql-general by date:

Previous
From: Michael Harris
Date:
Subject: Re: Undetected Deadlock
Next
From: Lucas
Date:
Subject: PostgreSQL Management and monitoring tool