Re: Support for REINDEX CONCURRENTLY - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Support for REINDEX CONCURRENTLY
Date
Msg-id CAB7nPqTEFOTrM=HKjEf1s6aTN=j09t7d=w3-A-7cVh6y8tN2fw@mail.gmail.com
Whole thread Raw
In response to Re: Support for REINDEX CONCURRENTLY  (Stephen Frost <sfrost@snowman.net>)
Responses Re: Support for REINDEX CONCURRENTLY  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-hackers
Hi all,

Please find attached the version 2 of the patch for this feature, it corrects the following things:
- toast relations are now rebuilt concurrently as well as other indexes
- concurrent constraint indexes (PRIMARY KEY, UNIQUE, EXCLUSION) are dropped correctly at the end of process
- exclusion constraints are supported, at least it looks to work correctly.
- Fixed a couple of bugs when constraint indexes were involved in process.

I am adding this version to the commit fest of next month for review.
Regards,
--
Michael Paquier
http://michael.otacoo.com
Attachment

pgsql-hackers by date:

Previous
From: David Johnston
Date:
Subject: Re: Potential autovacuum optimization: new tables
Next
From: Stephen Frost
Date:
Subject: Re: Potential autovacuum optimization: new tables