Subject: pgsql: Release the exclusive lock on the table early after truncating it
From: tgl@sss.pgh.pa.us (Tom Lane)
Date: 9/10/2007 8:25:06 PM
alvherre@postgresql.org (Alvaro Herrera) writes:
> Release the exclusive lock on the table early after truncating it in lazy
> vacuum, instead of waiting till commit.
Weren't you going to disable vacuum_delay in that stretch of code, too?
BTW, not sure if you realized this, but just deleting the
vacuum_delay_point call is probably a bad idea --- replace it
with CHECK_FOR_INTERRUPTS() instead.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
|