Quick Links

Re: Undetected Deadlock

From:	Michael Lewis <mlewis(at)entrata(dot)com>
To:	Michael Harris <harmic(at)gmail(dot)com>
Cc:	Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject:	Re: Undetected Deadlock
Date:	2022-01-27 01:14:26
Message-ID:	CAHOFxGr_KbbBCeU9RtDPwszqbci0NEtT+Uo3RM5k=N9TQSSsGg@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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

In response to

Re: Undetected Deadlock at 2022-01-27 00:20:59 from Michael Harris

Responses

Re: Undetected Deadlock at 2022-01-27 02:54:42 from Michael Harris

Browse pgsql-general by date

	From	Date	Subject
Next Message	Lucas	2022-01-27 01:28:17	PostgreSQL Management and monitoring tool
Previous Message	Michael Harris	2022-01-27 00:20:59	Re: Undetected Deadlock