From: Gourish Singbal <gourish@gmail.com>
To: Jim C. Nasby <jnasby@pervasive.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Autovacuuming
Date: Tue, 25 Apr 2006 11:33:00 +0530
Message-ID: <674d1f8a0604242303w15be5f2oe4ba806873d1984d@mail.gmail.com> (raw)
In-Reply-To: <20060424175115.GF48010@pervasive.com>
References: <674d1f8a0604232251v4649b456xc542fd831f8db4@mail.gmail.com>
<20060424175115.GF48010@pervasive.com>
Thanks for the reply. we will be reviewing the settings soon.
Also have manually ran the database-wide vacuum on the 50GB database . (for
safety reasons). the transaction count is 1147399191. we plan to automate
this process once a month or so.
Do we need to Disable the Auto-vacuum deamon when we manually run the
database-wide vacuum command ?.
thanks in advance.
On 4/24/06, Jim C. Nasby <jnasby@pervasive.com> wrote:
>
> On Mon, Apr 24, 2006 at 11:21:16AM +0530, Gourish Singbal wrote:
> > The Age of the database is 1144759836 . We have enabled autovacuuming .
> > The details are:-
> > autovacuum = on
> > autovacuum_naptime = 300
> > autovacuum_vacuum_threshold = 10000
> > autovacuum_analyze_threshold = 5000
> > autovacuum_vacuum_scale_factor = 0.3
> > autovacuum_analyze_scale_factor = 0.3
>
> Those settings are *really* conservative... I normally use 400, 200,
> 0.2, 0.1 respectively...
>
> > Wanted to know when the auto-vacuum daemon will run an
> database-wide vacuum
> > call to avoid transaction ID wraparound failures.
>
> IIRC it will do that somewhere between 2B and 4B transactions have
> elapsed. The true answer lies somewhere in
> src/backend/postmaster/autovacuum.c.
> --
> Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
> Pervasive Software http://pervasive.com work: 512-231-6117
> vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
>
--
Best,
Gourish Singbal
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: gourish@gmail.com, jnasby@pervasive.com
Subject: Re: Autovacuuming
In-Reply-To: <674d1f8a0604242303w15be5f2oe4ba806873d1984d@mail.gmail.com>
References: <674d1f8a0604232251v4649b456xc542fd831f8db4@mail.gmail.com> <20060424175115.GF48010@pervasive.com> <674d1f8a0604242303w15be5f2oe4ba806873d1984d@mail.gmail.com>
* 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