On 6 5 , 9 12 , bnich...@xxxxxxxxxxxxxxx (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.
