On 6 5 , 9 12 , bnich(dot)(dot)(dot)(at)ca(dot)afilias(dot)info (Brad Nicholson) wrote:
> On Tue, 2007-06-05 at 03:33 -0700, Charles.Hou wrote:
> > how can i know that it's the time to vacuumdb? i set the crontab to
> > vacuumdb 3 times in one day. because my database size increase from
> > 440MB to 460MB in 8 hours.
>
> Have you looked at autovaccum? It can handle this for you.
>
> If not, you need to examine the output of VACUUM VERBOSE or pg_stattuple
> (in contrib) and set a policy based on the output.
>
> It's entirely possible that some tables will need to get vacuumed
> frequently, and others will not.
>
> --
> Brad Nicholson 416-673-4106
> Database Administrator, Afilias Canada Corp.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
where is the contrib directory? i can't find it.