Re: Vacuum Full - stops responding(?)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Vacuum Full - stops responding(?)
Дата
Msg-id 12896.1255991924@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Vacuum Full - stops responding(?)  (Krowa Krowax <krowa333@gmail.com>)
Ответы Re: Vacuum Full - stops responding(?)  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-admin
Krowa Krowax <krowa333@gmail.com> writes:
> INFO:  vacuuming "pg_toast.pg_toast_17929229"
> INFO:  "pg_toast_17929229": found 6203 removable, 257509 nonremovable
> row versions in 20509016 pages
> DETAIL:  0 dead row versions cannot be removed yet.
> Nonremovable row versions range from 45 to 2030 bytes long.
> There were 87521183 unused item pointers.
> Total free space (including removable row versions) is 166910212580 bytes.
> 20384082 pages are or will become empty, including 3 at the end of the table.
> 20507826 pages containing 166910155528 free bytes are potential move
> destinations.

That might be about the worst case of table bloat I've ever seen :-(

> After 10 hours nothing new appear... What is going on with this vacuum?

It's trying to repack your table in place.  On the whole, I'd suggest
you cancel the vacuum and try a CLUSTER or some such instead.

After you get this cleaned up, think about enabling autovacuum ...

            regards, tom lane

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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Vacuum Full - stops responding(?)
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Vacuum Full - stops responding(?)