Gregory Stark <stark@enterprisedb.com> writes:
>> If you make the change suggested above, I think you don't need to do
>> things differently in C.I.C.
> It seems to me if you wait out transactions as you come across them you could
> end up waiting a whole lot longer than the way it works now where it waits
> them all out at the end of the first pass.
I think you might have misread that --- I intended to say that C.I.C
could still work the way it does today, not that it would be exactly
like regular CREATE INDEX. The wait-out business should only be needed
for a regular CREATE INDEX, and in that case there's no cumulative
waiting effect because no new conflicting transactions are coming in.
C.I.C. should be able to fix things up in its second pass instead of
waiting during the first one.
regards, tom lane