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 64DBE11F6AB5 for ; Mon, 24 Apr 2006 02:51:21 -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 90271-05 for ; Mon, 24 Apr 2006 02:51:17 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.201]) by postgresql.org (Postfix) with ESMTP id 413C011F6A9C for ; Mon, 24 Apr 2006 02:51:17 -0300 (ADT) Received: by nz-out-0102.google.com with SMTP id o1so753764nzf for ; Sun, 23 Apr 2006 22:51:16 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=GRF0yE2jVuXaqmK4RRj8tjCwxb1HRsTdnvK+aYq388pyN644UXApShLHm9WJX+swi6W4dtXeyYg37CFWQQKfZqYbSdI7PKG3GIAON7/SyJ8xnJNL598P/3KQSS65lnB5WX4lfkXhZGKyHJP1yuPCxueQsU0nKHXSixEVgs1UiQI= Received: by 10.36.215.21 with SMTP id n21mr6363671nzg; Sun, 23 Apr 2006 22:51:16 -0700 (PDT) Received: by 10.36.68.5 with HTTP; Sun, 23 Apr 2006 22:51:16 -0700 (PDT) Message-ID: <674d1f8a0604232251v4649b456xc542fd831f8db4@mail.gmail.com> Date: Mon, 24 Apr 2006 11:21:16 +0530 From: "Gourish Singbal" To: "pgsql-admin@postgresql.org" Subject: Autovacuuming MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_17838_14411033.1145857876852" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/228 X-Sequence-Number: 21397 ------=_Part_17838_14411033.1145857876852 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 Wanted to know when the auto-vacuum daemon will run an database-wide vacuu= m call to avoid transaction ID wraparound failures. ~ gourish singbal ------=_Part_17838_14411033.1145857876852 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
 
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

Wanted to= know when the auto-vacuum daemon will run an database-wide  vacuum ca= ll to avoid transaction ID wraparound failures.

~ gourish singbal ------=_Part_17838_14411033.1145857876852--