Re: Vacuum blocking... - Mailing list pgsql-admin

From Tom Lane
Subject Re: Vacuum blocking...
Date
Msg-id 11603.1018963912@sss.pgh.pa.us
Whole thread Raw
In response to Vacuum blocking...  (Jean-Arthur Silve <jeanarthur@eurovox.fr>)
List pgsql-admin
Jean-Arthur Silve <jeanarthur@eurovox.fr> writes:
> Now, vacuum "blocks" on one table (apparently "comptes" table) , without HD
> activity, no error message....

Curious.  Do you want to get in there with a debugger and see where it's
looping?

> PS : I use 7.0 version

Hmm ... are you on 7.0.3?  There's a known bug in earlier releases that
could perhaps lead to an endless loop in VACUUM.

The simplest answer is probably "past time to update to 7.2.1", anyway.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Benjamin Lara"
Date:
Subject: Postgresql on win2000
Next
From: Edipo Elder Fernandes de Melo
Date:
Subject: Re: psql command line history not working