| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | Stephen Frost <sfrost(at)snowman(dot)net> |
| Cc: | Jim Nasby <jim(at)nasby(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Andres Freund <andres(at)2ndquadrant(dot)com>, Greg Stark <stark(at)mit(dot)edu>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Support for REINDEX CONCURRENTLY |
| Date: | 2012-10-13 02:50:44 |
| Message-ID: | CAB7nPqTEFOTrM=HKjEf1s6aTN=j09t7d=w3-A-7cVh6y8tN2fw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 | Content-Type | Size |
|---|---|---|
| 20121012_reindex_concurrent_v2.patch | application/octet-stream | 59.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2012-10-13 02:53:10 | Re: Potential autovacuum optimization: new tables |
| Previous Message | David Johnston | 2012-10-13 02:50:33 | Re: Potential autovacuum optimization: new tables |