Re: vacuum full problem - Mailing list pgsql-admin

From pginfo
Subject Re: vacuum full problem
Date
Msg-id 3FB09C68.2003C6F9@t1.unisoftbg.com
Whole thread Raw
In response to vacuum full problem  (pginfo <pginfo@t1.unisoftbg.com>)
Responses Re: vacuum full problem  (Gaetano Mendola <mendola@bigfoot.com>)
Re: vacuum full problem  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-admin
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.




pgsql-admin by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: vacuum full problem
Next
From: Gaetano Mendola
Date:
Subject: Re: vacuum full problem