| From: | Florian Weimer <fweimer(at)bfk(dot)de> |
|---|---|
| To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Deadlock during CREATE INDEX CONCURRENTLY, but index still created |
| Date: | 2011-05-18 15:32:59 |
| Message-ID: | 828vu4uiqc.fsf@mid.bfk.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
* Scott Marlowe:
> On Wed, May 18, 2011 at 9:19 AM, Florian Weimer <fweimer(at)bfk(dot)de> wrote:
>> I've run two CREATE INDEX CONCURRENTLY on the same table in parallel,
>> and one of them errored out with:
>> The curious thing is that both indexes were created. I would have
>> expected that the creation of idx1 would be rolled back.
>>
>> Are both of the usable, or should I re-create idx1 from scratch?
>
> They should be marked invalid.
Ah, thanks, I see it now. I guess this answers my question. 8-)
--
Florian Weimer <fweimer(at)bfk(dot)de>
BFK edv-consulting GmbH http://www.bfk.de/
Kriegsstraße 100 tel: +49-721-96201-1
D-76133 Karlsruhe fax: +49-721-96201-99
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2011-05-18 15:33:17 | Re: Deadlock during CREATE INDEX CONCURRENTLY, but index still created |
| Previous Message | Florian Weimer | 2011-05-18 15:19:21 | Deadlock during CREATE INDEX CONCURRENTLY, but index still created |