Re: Reindex does not finish 8.2.6

From: "Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com>
To: Clodoaldo <clodoaldo(dot)pinto(dot)neto(at)gmail(dot)com>
Cc: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, "PostgreSQL - General ML" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Reindex does not finish 8.2.6
Date: 2008-03-14 09:21:12
Message-ID: 2e78013d0803140221j53211eb1pc84bb1dde46a275c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Mar 14, 2008 at 5:19 AM, Clodoaldo
<clodoaldo(dot)pinto(dot)neto(at)gmail(dot)com> wrote:

>
> > Try vacuuming pg_class, pg_index, pg_attribute manually and see if that
> > makes the problem go away.
>
> It does not go away.
>

Can it be a case where some other open transaction is holding a lock
on the table ? Note that REINDEX would block even some other transaction
is inserting/deleting/updating the table.

Thanks,
Pavan

--
Pavan Deolasee
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2008-03-14 09:27:58 Re: postgre vs MySQL
Previous Message Enrico Sirola 2008-03-14 09:04:01 pgbench not setting scale size correctly?