Re: Reindex does not finish 8.2.6

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

=> select locktype, mode, granted, count(*) as total
from pg_locks group by locktype, mode, granted;
   locktype    |      mode       | granted | total
---------------+-----------------+---------+-------
 relation      | AccessShareLock | t       |   112
 transactionid | ExclusiveLock   | t       |    17
(2 rows)

Regards, Clodoaldo Pinto Neto