[ADMIN] Vacuum blocking...

2002-04-18 Thread Jean-Arthur Silve
Hello ! I used to run vacuum verbose analyze (vacuumdb -v -a -z) every days. Everything was ok for months until yesterday ! Usually, this command takes about 1 mn. Now, vacuum "blocks" on one table (apparently "comptes" table) , without HD activity, no error message avr 15 10:31:27 uranus

[ADMIN] Vacuum blocking...

2002-04-17 Thread Jean-Arthur Silve
Hello ! I used to run vacuum verbose analyze (vacuumdb -v -a -z) every days. Everything was ok for months until yesterday ! Usually, this command takes about 1 mn. Now, vacuum "blocks" on one table (apparently "comptes" table) , without HD activity, no error message avr 15 10:31:27 uranus

Re: [ADMIN] Vacuum blocking...

2002-04-16 Thread Tom Lane
Jean-Arthur Silve <[EMAIL PROTECTED]> 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? The

[ADMIN] Vacuum blocking...

2002-04-16 Thread Jean-Arthur Silve
Hello ! I used to run vacuum verbose analyze (vacuumdb -v -a -z) every days. Everything was ok for months until yesterday ! Usually, this command takes about 1 mn. Now, vacuum "blocks" on one table (apparently "comptes" table) , without HD activity, no error message avr 15 10:31:27 uranus