Horton

Re: Undetected Deadlock

Michael Lewis <mlewis@entrata.com>

View thread View on postgr.es
From: Michael Lewis <mlewis@entrata.com>
To: Michael Harris <harmic@gmail.com>
Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>, pgsql-general@lists.postgresql.org
Date: 2022-01-27T01:14:26Z
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

Commits

  1. Make timeout.c more robust against missed timer interrupts.

  2. Improve timeout.c's handling of repeated timeout set/cancel.