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

Re: [HACKERS] Autovacuum loose ends

From: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
To: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-patches(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Autovacuum loose ends
Date: 2005-07-26 15:45:19
Message-ID: 42E65A8F.70705@zeut.net (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Alvaro Herrera wrote:

>Two comments still apply:
>
>- I haven't done anything yet w.r.t. the custom vacuum_delay nor sleep
>  scale factor.
>

I don't think we need the sleep scaling factor.  Before we had vacuum 
delay settings, it might have been useful as a means of throttling down 
the impact of autovacuum, but I think the delay settings are the better 
way to go.

As for the custom vacuum_delay settings, Tom Lane's  commented that it 
probably wasn't needed.  However I and several others responded saying 
that it probably would be useful for certain use cases.  I'm still not 
sure how compelling that case is but it seems like a simple addition.  
Perhaps this is something we can add for 8.2 if people seem to want it.

>- There are still no docs.
>


I'm on the hook for this and will start working on them next week.



In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2005-07-26 16:44:57
Subject: Re: [PATCHES] Roles - SET ROLE Updated
Previous:From: Tom LaneDate: 2005-07-26 14:39:14
Subject: Re: Rollback issue with SET ROLE

pgsql-patches by date

Next:From: Tom LaneDate: 2005-07-26 16:44:57
Subject: Re: [PATCHES] Roles - SET ROLE Updated
Previous:From: Neil ConwayDate: 2005-07-26 06:00:24
Subject: Re: User's exception plpgsql

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