Re: Reindex does not finish 8.2.6

2008/3/14, Alvaro Herrera <alvherre(at)commandprompt(dot)com>:
> Clodoaldo escribió:
>
>
> > Postgresql was restarted twice, but yes, it is as if the crash left
> > some kind of permanent lock somewhere.
>
>
> A prepared transaction perhaps? SELECT * FROM pg_prepared_xacts;
>
> A quick look into pg_locks should tell you if it's blocking.

pg_prepared_xacts is empty and pg_locks has 288 rows:

# select locktype, mode, count(*) as total
from pg_locks group by locktype, mode;
locktype | mode | total
---------------+------------------+-------
transactionid | ExclusiveLock | 30
relation | RowExclusiveLock | 2
relation | AccessShareLock | 256
(3 rows)

Regards, Clodoaldo Pinto Neto