Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group