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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
