Re: One vacuum full is not enough.

Поиск
Список
Период
Сортировка
От Hannu Krosing
Тема Re: One vacuum full is not enough.
Дата
Msg-id 1110386371.5518.2.camel@fuji.krosing.net
обсуждение исходный текст
Ответ на One vacuum full is not enough.  (Gaetano Mendola <mendola@bigfoot.com>)
Ответы Re: One vacuum full is not enough.
Список pgsql-hackers
Ühel kenal päeval (teisipäev, 8. märts 2005, 00:52+0100), kirjutas
Gaetano Mendola:
> Hi all,
> running a 7.4.5 it happen to me with another table
> where a single vacuum full was not freeing enough pages,
> here the verbose vacuum full, as you can see only at
> the end:  truncated 8504 to 621 pages.
>
> I use pg_autovacuum and it's not enough. I'll schedule
> again a nightly vacuum full.

You may have too few fsm pages, so new inserts/updates don't use all the pages freed by vacuums.

--
Hannu Krosing <hannu@tm.ee>


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

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: fool-toleranced optimizer
Следующее
От: Oleg Bartunov
Дата:
Сообщение: pgpool question