Vacuum blocking...

Поиск
Список
Период
Сортировка
От Jean-Arthur Silve
Тема Vacuum blocking...
Дата
Msg-id 5.1.0.14.0.20020416094730.03a128e0@mail.eurovox.fr
обсуждение исходный текст
Ответ на Re: Max Number of Databases on a Server.  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Vacuum blocking...
Список 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

В списке pgsql-admin по дате отправления: