| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | Jim Nasby <Jim(dot)Nasby(at)bluetreble(dot)com> |
| Cc: | Andres Freund <andres(at)2ndquadrant(dot)com>, PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: REINDEX CONCURRENTLY 2.0 |
| Date: | 2014-11-06 04:49:11 |
| Message-ID: | CAB7nPqTaVVwBGRhR-voFxjN6V2NHDq64=kVWq1C=YxdNKY4GXg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Oct 30, 2014 at 5:19 PM, Michael Paquier
<michael(dot)paquier(at)gmail(dot)com> wrote:
> Updated patch is attached.
Please find attached an updated patch with the following things changed:
- Addition of tab completion in psql for all new commands
- Addition of a call to WaitForLockers in index_concurrent_swap to
ensure that there are no running transactions on the parent table
running before exclusive locks are taken on the index and its
concurrent entry. Previous patch versions created deadlocks because of
that, issue spotted by the isolation tests integrated in the patch.
- Isolation tests for reindex concurrently are re-enabled by default.
Regards,
--
Michael
| Attachment | Content-Type | Size |
|---|---|---|
| 20141106_reindex_concurrently_3_v3.patch | text/x-diff | 87.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jaime Casanova | 2014-11-06 05:38:05 | Re: Amazon Redshift |
| Previous Message | mariem | 2014-11-06 03:32:41 | Re: Convert query plan to sql query |