Re: Reindex does not finish 8.2.6

2008/3/14, Alvaro Herrera <alvherre@commandprompt.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