Re: Reindex does not finish 8.2.6

Clodoaldo escribió:
> 2008/3/14, Alvaro Herrera <alvherre@commandprompt.com>:

> >  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)

How many of them have granted=false?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support