From: Simon Riggs <simon@2ndQuadrant.com>
To: Scott Whitney <swhitney@journyx.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Autovac vs manual with analyze
Date: Thu, 18 Mar 2010 09:02:22 +0000
Message-ID: <1268902942.3827.1696.camel@ebony> (raw)
In-Reply-To: <18735708.169861268677235843.JavaMail.root@zimbra.int.journyx.com>
References: <18735708.169861268677235843.JavaMail.root@zimbra.int.journyx.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: simon@2ndQuadrant.com, swhitney@journyx.com
Subject: Re: Autovac vs manual with analyze
In-Reply-To: <1268902942.3827.1696.camel@ebony>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox