Skip site navigation (1) Skip section navigation (2)

Vacuum blocking...

From: Jean-Arthur Silve <jeanarthur(at)eurovox(dot)fr>
To: pgsql-admin(at)postgresql(dot)org
Subject: Vacuum blocking...
Date: 2002-04-16 07:58:03
Message-ID: 5.1.0.14.0.20020416094730.03a128e0@mail.eurovox.fr (view raw or flat)
Thread:
Lists: pgsql-admin
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 logger: NOTICE:  --Relation comptes--
avr 15 10:31:27 uranus logger: NOTICE:  Pages 492: Changed 26, reaped 491, 
Empty 0, New 0; Tup 6900: Vac 6229, Keep/VTL 0/0, Crash 0, UnUsed 694, 
MinLen 242, MaxLen 698; Re-using: Free/Avail. Space 1946648/1943020; 
EndEmpty/Avail. Pages 0/456. CPU 0.04s/0.27u sec.

Then, nothing happens...

Any idea ?
PS : I use 7.0 version

jean-arthur



In response to

Responses

pgsql-admin by date

Next:From: Gianmarco PiolaDate: 2002-04-16 09:32:39
Subject: new problems
Previous:From: Peter DarleyDate: 2002-04-16 06:46:30
Subject: Re: ODBC Problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group