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

From Tom Lane
Subject Re: [GENERAL] Concurrency problem building indexes
Date
Msg-id 7980.1145925761@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] Concurrency problem building indexes  ("Jim C. Nasby" <jnasby@pervasive.com>)
Responses Re: [GENERAL] Concurrency problem building indexes  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-hackers
"Jim C. Nasby" <jnasby@pervasive.com> writes:
> Was the code ever changed so that it won't update relpages if the number
> is the same?

Long ago.  I just tested it again, and AFAICS you can create indexes
concurrently so long as the underlying table isn't changing (ie,
neither reltuples nor relpages changes).
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: [GENERAL] Concurrency problem building indexes
Next
From: "Jim C. Nasby"
Date:
Subject: Re: [GENERAL] Concurrency problem building indexes