X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id CB0BB11F60A9 for ; Tue, 25 Apr 2006 03:03:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 29290-07 for ; Tue, 25 Apr 2006 03:03:02 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.199]) by postgresql.org (Postfix) with ESMTP id B12D211F60B0 for ; Tue, 25 Apr 2006 03:03:01 -0300 (ADT) Received: by nz-out-0102.google.com with SMTP id o1so986950nzf for ; Mon, 24 Apr 2006 23:03:01 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=tvbjrZGSn5xs2U1D8WVbiV5MFq03gq9LR9iU7FoTzvcj7ig6nOuXxWEat57KKrKCuLBCoOG6hy3gR+U3sHDaFN9q+qClAgbTrevIEZ/SPVRqGx9khD5y1FYIUNfhaFrXP4faJf2SwhOz2166zNnSiQ8NtSznlHQOcY7hftHQHig= Received: by 10.36.60.16 with SMTP id i16mr4989nza; Mon, 24 Apr 2006 23:03:00 -0700 (PDT) Received: by 10.36.68.5 with HTTP; Mon, 24 Apr 2006 23:03:00 -0700 (PDT) Message-ID: <674d1f8a0604242303w15be5f2oe4ba806873d1984d@mail.gmail.com> Date: Tue, 25 Apr 2006 11:33:00 +0530 From: "Gourish Singbal" To: "Jim C. Nasby" Subject: Re: Autovacuuming Cc: "pgsql-admin@postgresql.org" In-Reply-To: <20060424175115.GF48010@pervasive.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_133_14134752.1145944980809" References: <674d1f8a0604232251v4649b456xc542fd831f8db4@mail.gmail.com> <20060424175115.GF48010@pervasive.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/260 X-Sequence-Number: 21429 ------=_Part_133_14134752.1145944980809 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Thanks for the reply. we will be reviewing the settings soon. Also have manually ran the database-wide vacuum on the 50GB database . (fo= r 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 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 =3D on > > autovacuum_naptime =3D 300 > > autovacuum_vacuum_threshold =3D 10000 > > autovacuum_analyze_threshold =3D 5000 > > autovacuum_vacuum_scale_factor =3D 0.3 > > autovacuum_analyze_scale_factor =3D 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 ------=_Part_133_14134752.1145944980809 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
 
Thanks for the reply. we will be reviewing the settings soon.
Also have manually ran the database-wide vacuum on the 50GB database&n= bsp;.  (for safety reasons). the transaction count is 1147399191. we p= lan 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@pervasi= ve.com> wrote:
On Mon, Apr 24, 2006 at 11:21:16= AM +0530, Gourish Singbal wrote:
> The Age of the database is 1144759= 836 . We have enabled autovacuuming .
> The details are:-
> autovacuum =3D on
> autovacuum_nap= time =3D 300
> autovacuum_vacuum_threshold =3D 10000
> autovacu= um_analyze_threshold =3D 5000
> autovacuum_vacuum_scale_factor =3D 0.= 3
> autovacuum_analyze_scale_factor =3D=20 0.3

Those settings are *really* conservative... I normally use 400, = 200,
0.2, 0.1 respectively...

> Wanted to know when the auto-v= acuum daemon will run an database-wide  vacuum
> call to av= oid transaction ID wraparound failures.

IIRC it will do that somewhere between 2B and 4B transactions have<= br>elapsed. The true answer lies somewhere in
src/backend/postmaster/aut= ovacuum.c.
--
Jim C. Nasby, Sr. Engineering Consultant  &nb= sp;    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=20 ------=_Part_133_14134752.1145944980809--