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

pg_autovacuum vacuum cost variables patch

From: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
To: pgsql-patches <pgsql-patches(at)postgresql(dot)org>
Subject: pg_autovacuum vacuum cost variables patch
Date: 2004-10-26 05:40:11
Message-ID: 417DE33B.4090505@zeut.net (view raw or flat)
Thread:
Lists: pgsql-patches
Hello, as per some discussion on the lists a few days ago, I am 
submitting this patch against the CVS version of pg_autovacuum. 

This patch adds 5 new command line options to pg_autovacuum that 
directly correspond to the 5 new vacuum cost GUC variables in 8.0.   I 
have done some simple testing and this patch works Ok on my FC3 box.

Two questions: 
1) It is my understanding that these new GUC vars only effect vacuum.  
That is they do NOT have any effect on an analyze command right? (I ask 
since I'm only setting the vars before I issue a vacuum command)
2) Does anyone have any better suggestions for the letters used for the 
new pg_autovacuum command line args?  Nothing obvious came to mind, so I 
just basically picked at random resulting in this:
-c    vacuum_cost_delay
-C  vacuum_cost_page_hit
-m    vacuum_cost_page_miss
-n    vacuum_cost_page_dirty
-N    vacuum_cost_limit
Any better ideas?


 Please review and if deemed accecptable, please apply to CVS HEAD.

Thanks,

Matthew O'Connor


Attachment: pg_autovacuum_vacuum_cost.diff
Description: text/x-patch (9.5 KB)

Responses

pgsql-patches by date

Next:From: Tom LaneDate: 2004-10-26 05:53:55
Subject: Re: [PATCHES] ARC Memory Usage analysis
Previous:From: Greg StarkDate: 2004-10-26 05:27:29
Subject: Re: [PATCHES] ARC Memory Usage analysis

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