Re: deadlock while re-indexing table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Dave Cramer <pg(at)fastcrypt(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: deadlock while re-indexing table
Date: 2008-02-12 15:49:00
Message-ID: 26873.1202831340@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> Can we rework REINDEX TABLE so that it processes each index on its own
> transaction?

It still wouldn't be guaranteed deadlock-free. There might be fewer
cases, but whether it would help Dave's particular case is just
speculation when we don't know what that case is.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Stark 2008-02-12 15:59:21 Re: deadlock while re-indexing table
Previous Message Alvaro Herrera 2008-02-12 15:45:02 Re: deadlock while re-indexing table