On Mon, 2010-03-15 at 13:20 -0500, Scott Whitney wrote: > My problem is that each Saturday at midnight, I have to start a > vacuumdb -f -z -a or my pg_clog dir never clears out. Why is your pg_clog dir a problem? > So, my questions are: > > a) Is the manual vacuum needed for performance reasons, or is auto-vac > sufficient? If you don't know why you are running it, then you should skip it and measure the difference. -- Simon Riggs www.2ndQuadrant.com -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
