Re: Vacuuming

Поиск
Список
Период
Сортировка
Искать
От
Devrim GÜNDÜZ
Тема
Re: Vacuuming
Дата
Msg-id
1266106999.2012.49.camel@hp-laptop2.gunduz.org
Ответ на
Re: Vacuuming (Frank Bax)
Список
Дерево обсуждения
Vacuuming peter@vfemail.net
Re: Vacuuming APseudoUtopia <apseudoutopia@gmail.com>
Re: Vacuuming Frank Bax <fbax@sympatico.ca>
Re: Vacuuming Mladen Gogala <mladen.gogala@vmsinfo.com>
Re: Vacuuming Frank Bax <fbax@sympatico.ca>
Re: Vacuuming Devrim GÜNDÜZ <devrim@gunduz.org>
On Sat, 2010-02-13 at 19:08 -0500, Frank Bax wrote:
> It's now 19:06 and no autovacuum; why not?

...it is because of the remaining autovac settings. Autovac determines
the relations to be vacuumed based on the scale_factor and threshold
settings. Enabling autovacuum does not necessarily mean that it will
vacuum tables.

See:

http://www.postgresql.org/docs/current/static/routine-vacuuming.html#AUTOVACUUM.

-- 
Devrim GÜNDÜZ, RHCE
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz
В списке pgsql-novice по дате отправления
От: Frank Bax
Дата:
Сообщение: Re: Vacuuming
От: Mag Gam
Дата:
Сообщение: storing a text file
FAQ