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.