Re: [GENERAL] Concurrency problem building indexes - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [GENERAL] Concurrency problem building indexes
Date
Msg-id 9505.1145937776@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] Concurrency problem building indexes  (Wes <wespvp@syntegra.com>)
Responses Re: [GENERAL] Concurrency problem building indexes  (Wes <wespvp@syntegra.com>)
List pgsql-hackers
Wes <wespvp@syntegra.com> writes:
> I can duplicate the error at will.

[ shrug... ]  Worksforme.

There is a short interval at the end of the first CREATE INDEX on the
table where the problem would happen if another CREATE INDEX tries to
modify the pg_class row before the first one's committed.  That would be
hard to hit with any regularity though.  Subsequent CREATE INDEXes after
that should be completely reliable.  If you are modifying the table
while it's being indexed, then the same small window would apply for
each CREATE INDEX not just the first ... but you didn't admit to that.

Care to put together a self-contained test case?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Wes
Date:
Subject: Re: [GENERAL] Concurrency problem building indexes
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Google SoC--Idea Request