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

Re: pgsql-server: Vacuum delay activated by default.

From: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>,Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Jan Wieck <JanWieck(at)Yahoo(dot)com>,pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql-server: Vacuum delay activated by default.
Date: 2004-08-07 17:50:07
Message-ID: 20040807144908.N1212@ganymede.hub.org (view raw or flat)
Thread:
Lists: pgsql-committers
On Sat, 7 Aug 2004, Bruce Momjian wrote:

> Marc G. Fournier wrote:
>> On Sat, 7 Aug 2004, Tom Lane wrote:
>>
>>> Jan Wieck <JanWieck(at)Yahoo(dot)com> writes:
>>>> On 8/7/2004 12:47 AM, Tom Lane wrote:
>>>>> What?  If there was consensus to do this, I missed it.  If there was
>>>>> even any *discussion* of doing this, I missed it.
>>>
>>>> How many questions about vacuum still grabbing all available bandwidth,
>>>> vacuum slowing down the whole system, vacuum being all evil do you want
>>>> to answer for 8.0? Over and over again we are defending reasonable
>>>> default configuration values against gazillions of little switches, and
>>>> this is a reasonable default that will be a relief for large databases
>>>> and makes more or less no difference for small ones.
>>>
>>> What basis do you have for saying that this is a reasonable default?
>>> Does anyone else agree?
>>
>> Just curious, but isn't this one of the key points about pg_autovacuum in
>> the first place?  So that you vacuum what needs to be vacuum'd, and not
>> *everything* ... ?  Shouldn't the answer to the 'bandwidth issue' change
>> to 'you should install/use pg_autovacuum'?
>
> We are talking about the vacuum delay feature, not pg_autovacuum.

Right, and your point?  That doesn't answer my question, only clarifies 
for everyone what we already know we're talking about, thank you ...

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy(at)hub(dot)org           Yahoo!: yscrappy              ICQ: 7615664

In response to

pgsql-committers by date

Next:From: Tom LaneDate: 2004-08-07 17:55:59
Subject: pgsql-server: Remove bogus trailing dot from eventlog output, per
Previous:From: Bruce MomjianDate: 2004-08-07 17:42:51
Subject: Re: pgsql-server: Vacuum delay activated by default.

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