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.
