Re: Some thoughts about i/o priorities and throttling vacuum - Mailing list pgsql-hackers

From Matthew T. O'Connor
Subject Re: Some thoughts about i/o priorities and throttling vacuum
Date
Msg-id 1066406423.13403.3.camel@zeutrh9
Whole thread Raw
In response to Re: Some thoughts about i/o priorities and throttling vacuum  (Shridhar Daithankar <shridhar_daithankar@persistent.co.in>)
List pgsql-hackers
On Fri, 2003-10-17 at 10:53, Shridhar Daithankar wrote:
> Matthew T. O'Connor wrote:
> > One additional thing, some of this might be possible if pg_autovacuum
> > saved its data between restarts.  Right now it restarts with no memory
> > of what happened before.  
> 
> Well, the unmaintened gborg version adopted approach of storing such info. in a 
> table, so that it survives postgresql/pg_atuvacuum restart or both.
> 
> That was considered a tablespace pollution back then. But personally I think, it 
> should be ok. If ever it goes to catalogues, I would rather add few columns to 
> pg_class for such a stat. But again, thats not my call to make.

I still consider it tablespace pollution, when / if it gets integrated
into the backend, and it uses system tables that is a different story,
you are not modifying a users database.  What should happen is that on
exit pg_autovacuum writes it's data to a file that it rereads on
startup, or something like that....



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Some thoughts about i/o priorities and throttling vacuum
Next
From: Christopher Browne
Date:
Subject: Re: Some thoughts about i/o priorities and throttling vacuum