Premsun Choltanwanich wrote:
Does it has a way to schedule the process for make sure that i'm running VACUUM
often enough? How?
(ie. create some script on PostgreSQL from running VACUUM FULL on 3.00 AM for
first date of every month.)
You might want to look at "autovacuum" in the contrib/ directory of the
source, or the equivalent package for your platform. It's part of the
core system in later versions.
Otherwise, there's a command-line "vacuumdb" tool which you can schedule
from cron (man 1 crontab / man 5 crontab). Depending on update activity
you might want to run a normal vacuum daily and vacuum full weekly, or
perhaps vacuum hourly and vacuum full overnight. You'll want to set the
max_fsm_xxx parameters in your postgresql.conf once you have things
running normally. There's a "verbose" option for vacuum full which can
help suggest values for these.
First of all though, run a vacuum full/reindex to compact everything,
then run vacuum regularly.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
