Re: Reindex does not finish 8.2.6 - Mailing list pgsql-general

From Pavan Deolasee
Subject Re: Reindex does not finish 8.2.6
Date
Msg-id 2e78013d0803140221j53211eb1pc84bb1dde46a275c@mail.gmail.com
Whole thread Raw
In response to Re: Reindex does not finish 8.2.6  (Clodoaldo <clodoaldo.pinto.neto@gmail.com>)
Responses Re: Reindex does not finish 8.2.6
List pgsql-general
On Fri, Mar 14, 2008 at 5:19 AM, Clodoaldo
<clodoaldo.pinto.neto@gmail.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

pgsql-general by date:

Previous
From: Enrico Sirola
Date:
Subject: pgbench not setting scale size correctly?
Next
From: Magnus Hagander
Date:
Subject: Re: postgre vs MySQL