Tom Lane wrote: > [EMAIL PROTECTED] (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.
Hmm, I didn't. Will fix. Actually, now that you mention it, I remember that Alexey Kluykin (a colleague from Command Prompt) had already mentioned it to me and I forgot :-( -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
