More VACUUM output?
От | Dmitry Tkach |
---|---|
Тема | More VACUUM output? |
Дата | |
Msg-id | 3EE9085E.4080801@openratings.com обсуждение исходный текст |
Ответы |
Re: More VACUUM output?
|
Список | pgsql-general |
First of all, Tom, thanks a lot for your repsonse! It helps... I have one more question (it is the same damn command - still running, since Tuesday morning!): NOTICE: --Relation dnb-- NOTICE: Index duns_idx: Pages 587975; Tuples 180289753: Deleted 13980845. CPU 268.47s/781.13u sec elapsed 3570.69 sec. NOTICE: Index sic_idx: Pages 553200; Tuples 180290790: Deleted 13980845. CPU 322.57s/743.92u sec elapsed 13081.00 sec. NOTICE: Index state_idx: Pages 699828; Tuples 156813148: Deleted 13980845. CPU 392.50s/735.70u sec elapsed 15806.45 sec. NOTICE: Index dnb_gist_idx: Pages 695689; Tuples 180297513: Deleted 13980845. CPU 408.83s/744.99u sec elapsed 16559.23 sec. NOTICE: Removed 13980845 tuples in 216626 pages. CPU 111.51s/104.37u sec elapsed 1352.91 sec. NOTICE: Index duns_idx: Pages 587978; Tuples 166317982: Deleted 13980846. CPU 232.80s/686.22u sec elapsed 3645.48 sec. NOTICE: Index sic_idx: Pages 553206; Tuples 166318925: Deleted 13980846. CPU 258.04s/636.63u sec elapsed 10390.20 sec. NOTICE: Index state_idx: Pages 699834; Tuples 142839792: Deleted 13980846. CPU 329.00s/646.69u sec elapsed 14384.46 sec. What does this mean? Has it started over? Why? Is it ever going to finish? Thanks a lot! Dima
В списке pgsql-general по дате отправления: