Alvaro Herrera <[EMAIL PROTECTED]> writes: > Tom Lane escribió: >> Not if someone else releases lock before committing.
> FWIW, a red flag raised for me here, though maybe it is irrelevant or > unimportant. Currently, VACUUM acquires an exclusive lock for > truncating the table. The lock is kept till commit. However I am > proposing that it be released before commit. I think that's all right, because it's dealing with a different set of concerns. AFAICS the only issue for truncation is to prevent physical access to the blocks in question until we can get rid of them. Once they're gone, if there wasn't an active seqscan (with an already-established notion of the max block number to scan to), there would be no reason for anyone to try to touch them. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend