Re: Problem Observed in behavior of Create Index Concurrently and Hot Update

Andres Freund <andres@2ndquadrant.com>

View thread

From: Andres Freund <andres@2ndquadrant.com>

To: Amit Kapila <amit.kapila@huawei.com>

Cc: pgsql-hackers@postgresql.org

Date: 2012-11-24T15:50:05Z

Lists: pgsql-hackers

Attachments

0001-Don-t-ignore-indisvalid-indisready-indexes-in-Relati.patch (text/x-patch)

Hi,

On 2012-10-31 11:41:37 +0530, Amit Kapila wrote:
> There seems to be a problem in behavior of Create Index Concurrently and Hot
> Update in HEAD code .

At pgcon.it I had a chance to discuss with Simon how to fix this
bug. Please check the attached patches - and their commit messages - for
the fix and some regression tests.
The fix contains at least one FIXME where I am not sure if we need to do
something additional and the locking behaviour deserves some close
review.

Opinions?

Greetings,

Andres Freund

-- 
 Andres Freund	                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services