pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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

view thread (11+ messages)  latest in thread

Message-ID: <674d1f8a0604242303w15be5f2oe4ba806873d1984d@mail.gmail.com>
Permalink:  ../674d1f8a0604242303w15be5f2oe4ba806873d1984d@mail.gmail.com/
Also on:    postgresql.org/message-id/674d1f8a0604242303w15be5f2oe4ba806873d1984d@mail.gmail.com

 · 

reply

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