Re: autovacuum

Поиск
Список
Период
Сортировка
От Bill Moran
Тема Re: autovacuum
Дата
Msg-id 20070920162747.f5b29c4a.wmoran@potentialtech.com
обсуждение исходный текст
Ответ на autovacuum  (Robert Fitzpatrick <lists@webtent.net>)
Список pgsql-general
In response to Robert Fitzpatrick <lists@webtent.net>:

> On Thu, 2007-09-20 at 13:22 -0400, Bill Moran wrote:
> > That doesn't mean you're vacuuming often enough, however.  Switch your
> > nightly vacuum to vacuum verbose and capture the output to see how much
> > work it has to do.  Are your fsm settings high enough?

<snip>

> INFO:  free space map contains 30078 pages in 41 relations
> DETAIL:  A total of 30304 page slots are in use (including overhead).
> 30304 page slots are required to track all free space.
> Current limits are:  204800 page slots, 1000 relations, using 1265 kB.

This was what I was most concerned about.  If your FSM settings are too
low, vacuum won't be able to fully do its job.  But it looks like you're
OK here.

--
Bill Moran
http://www.potentialtech.com

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

Предыдущее
От: Ilan Volow
Дата:
Сообщение: Re: Manually clearing "database "foo" is being accessed by other users"
Следующее
От: Bill Moran
Дата:
Сообщение: Re: autovacuum