Autovacuuming

From: "Gourish Singbal" <gourish(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Autovacuuming
Date: 2006-04-24 05:51:16
Message-ID: 674d1f8a0604232251v4649b456xc542fd831f8db4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

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

~ gourish singbal

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Robin Iddon 2006-04-24 09:20:24 Re: Problem with /usr/local/pgsql/bin/psql
Previous Message Alvaro Herrera 2006-04-24 01:02:55 Re: When cross database queries will be able