Re: Vacuuming - Mailing list pgsql-novice

From Devrim GÜNDÜZ
Subject Re: Vacuuming
Date
Msg-id 1266106999.2012.49.camel@hp-laptop2.gunduz.org
Whole thread Raw
In response to Re: Vacuuming  (Frank Bax <fbax@sympatico.ca>)
List pgsql-novice
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

Attachment

pgsql-novice by date:

Previous
From: Frank Bax
Date:
Subject: Re: Vacuuming
Next
From: Mag Gam
Date:
Subject: storing a text file