Re: HOT patch - version 14 - Mailing list pgsql-patches

From Tom Lane
Subject Re: HOT patch - version 14
Date
Msg-id 2661.1188516276@sss.pgh.pa.us
Whole thread Raw
In response to Re: HOT patch - version 14  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-patches
Alvaro Herrera <alvherre@commandprompt.com> 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

pgsql-patches by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: HOT patch - version 14
Next
From: "Pavan Deolasee"
Date:
Subject: Re: HOT patch - version 14