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

small changes to autovacuum maintainance

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: pgsql-patches(at)postgresql(dot)org
Subject: small changes to autovacuum maintainance
Date: 2005-09-16 04:33:58
Message-ID: 200509160033.58472.xzilla@users.sourceforge.net (view raw or flat)
Thread:
Lists: pgsql-patches
Attached patch takes a swing at improving the autovacuum wording in 
maintenance.sgml. 

On a related note I was thinking to add a note in the runtime config section 
for autovacuum_enabled that stats_start_collector and stats_row_level must be 
on for enabled to work, would that still go in runtime.sgml ?

On a related note to that, I am wondering if it might be better to have the 
postmaster issue a fatal error on startup if autovacuum is on and stats are 
off, rather than the warning it does now. ISTM it is very easy to miss that 
warning (since it is only sent to stderr and not stout afaict) and looking in 
pg_settings there would be no indication that anything was wrong, other than 
autovacuum being set to off (perhaps if it was set to 'error, stats disabled' 
or some such it might be better?)

-- 
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

Attachment: maintenance.sgml.patch
Description: text/x-diff (5.1 KB)

Responses

pgsql-patches by date

Next:From: Tom LaneDate: 2005-09-16 04:59:17
Subject: Re: small changes to autovacuum maintainance
Previous:From: Bruce MomjianDate: 2005-09-16 04:08:34
Subject: Re: sum(int4)/sum(int2) improvement

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