Re: Bloated Table

Поиск
Список
Период
Сортировка
От Alexander Schöcke
Тема Re: Bloated Table
Дата
Msg-id 4F1490B538ECAC4BA98D23915717B82D0105150E@winexch1.office.turtle-entertainment.de
обсуждение исходный текст
Ответ на Re: Bloated Table  (Bill Moran <wmoran@potentialtech.com>)
Список pgsql-general
>What is the output of VACUUM VERBOSE foobar_log?

INFO:  vacuuming "public.foobar_log"
INFO:  index "bar_index" now contains 23832007 row versions in 118151 pages
DETAIL:  0 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.02s/0.00u sec elapsed 64.10 sec.
INFO:  index "foobarid_foobar_log_key" now contains 23832007 row versions in 65347 pages
DETAIL:  0 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.02s/0.00u sec elapsed 32.60 sec.
INFO:  index "foo_foobar_log_key" now contains 23832007 row versions in 65347 pages
DETAIL:  0 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.03s/0.00u sec elapsed 25.14 sec.
INFO:  "foobar_log": found 0 removable, 23832007 nonremovable row versions in 269835 pages
DETAIL:  0 dead row versions cannot be removed yet.
There were 0 unused item pointers.
1 pages contain useful free space.
0 pages are entirely empty.
CPU 0.16s/0.09u sec elapsed 299.55 sec.
VACUUM

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

Предыдущее
От: Joshua Tolley
Дата:
Сообщение: Re: Postgres registry access using java
Следующее
От: Grzegorz Jaśkiewicz
Дата:
Сообщение: \dt+ on 8.4