Re: concurrent index builds unneeded lock? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: concurrent index builds unneeded lock?
Date
Msg-id 9403.1247285551@sss.pgh.pa.us
Whole thread Raw
In response to concurrent index builds unneeded lock?  (Theo Schlossnagle <jesus@omniti.com>)
Responses Re: concurrent index builds unneeded lock?
List pgsql-hackers
Theo Schlossnagle <jesus@omniti.com> writes:
> I would think it would be txns that would be reading that table, but  
> I'm thinking it is a bit to aggressive.  Am I reading the code wrong  
> there?  I'm thinking it should be more selective about vxids it  
> chooses to block on.  I'd expect it to block on vxids touching the  
> same table only.

There is no way to know whether a currently active vxid will try to look
at the other table later.  We can not just ignore this case...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Theo Schlossnagle
Date:
Subject: concurrent index builds unneeded lock?
Next
From: Robert Haas
Date:
Subject: Re: *_collapse_limit, geqo_threshold