From: | Jean-Arthur Silve <jeanarthur(at)eurovox(dot)fr> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Vacuum blocking... |
Date: | 2002-04-17 07:31:10 |
Message-ID: | 5.1.0.14.0.20020417093104.03a9e1d0@mail.eurovox.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Vassilis Takidis | 2002-04-17 11:39:38 | |
Previous Message | Bhuvan A | 2002-04-17 05:29:15 | Re: Help me! |