Re: vacuum full problem

Hi,
I can not be sure if it is not the case.
But we are usin this system on a number of servers and it happen only by
one.
Can I with a pg_locks help detect the query that is running?

regards,
ivan.

Stephan Szabo wrote:

> On Tue, 11 Nov 2003, Antonis Antoniou wrote:
>
> > Guys, does anyone has any idea?
>
> Are you sure that vacuum is not just waiting on a lock that some other
> transaction is holding?  I'd suggest checking the contents of pg_locks.