vacuum taking long time
От | Dale Walker |
---|---|
Тема | vacuum taking long time |
Дата | |
Msg-id | 39C13574.99E02887@icr.com.au обсуждение исходный текст |
Список | pgsql-general |
I have a machine inadvertently reboot on me this morning, and I have been running a vacuumdb command to try and check it. The vacuum command has processed the indexes OK, but it hasn't returned to a prompt as yet (3hrs) The table has only taken about 5min to do a vacuum on in the past... any suggestions?? This is what I have on my screen so far... ------------------------------------------------------------------ $ vacuumdb --dbname=icr --table=log --verbose --echo VACUUM VERBOSE log NOTICE: --Relation log-- NOTICE: Pages 17010: Changed 0, reaped 890, Empty 0, New 0; Tup 1031544: Vac 56920, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 114, MaxLen 126; Re-using: Free/Avail. Space 7048436/7048436; EndEmpty/Avail. Pages 0/890. CPU 1.95s/0.51u sec. NOTICE: Index idx_lacctterminatecause: Pages 2049; Tuples 1031544: Deleted 963. CPU 0.26s/1.76u sec. NOTICE: Index idx_lservicetype: Pages 2047; Tuples 1031544: Deleted 963. CPU 0.30s/1.71u sec. NOTICE: Index idx_lnasporttype: Pages 2047; Tuples 1031544: Deleted 962. CPU 0.30s/1.70u sec. NOTICE: Index idx_lnasport: Pages 2594; Tuples 1031544: Deleted 962. CPU 0.36s/1.72u sec. NOTICE: Index idx_lnasip: Pages 3595; Tuples 1031544: Deleted 962. CPU 0.39s/1.82u sec. NOTICE: Index idx_luser: Pages 3303; Tuples 1031544: Deleted 962. CPU 0.33s/1.90u sec. NOTICE: Index idx_loutdate: Pages 2569; Tuples 1031544: Deleted 962. CPU 0.35s/1.72u sec. NOTICE: Index log_pkey: Pages 2173; Tuples 1031544: Deleted 962. CPU 0.27s/1.75u sec. ----------------------------------------------------------------------------------- -- Dale Walker dale@icr.com.au Independent Computer Retailers (ICR) http://www.icr.com.au ICRnet http://www.icr.net.au
В списке pgsql-general по дате отправления: