Quick Links

Re: Autovac vs manual with analyze

From:	Simon Riggs <simon(at)2ndQuadrant(dot)com>
To:	Scott Whitney <swhitney(at)journyx(dot)com>
Cc:	pgsql-admin(at)postgresql(dot)org
Subject:	Re: Autovac vs manual with analyze
Date:	2010-03-18 09:02:22
Message-ID:	1268902942.3827.1696.camel@ebony
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-admin

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.

	From	Date	Subject
Next Message	Simon Riggs	2010-03-18 09:07:57	Re: PITR load on servers - increased 20%
Previous Message	Simon Riggs	2010-03-18 08:58:27	Re: pg_stop_backup()