Group: pgsql.committers


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