More VACUUM output?

Поиск
Список
Период
Сортировка
От Dmitry Tkach
Тема More VACUUM output?
Дата
Msg-id 3EE9085E.4080801@openratings.com
обсуждение исходный текст
Ответы Re: More VACUUM output?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Octavio Alvarez"
Дата:
Сообщение: Re: LC_COLLATE=es_MX in PgSQL 7.3.2
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Generalizing max and min