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

Re: [HACKERS] Autovacuum loose ends

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Michael Paesold <mpaesold(at)gmx(dot)at>,Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>,"Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>,pgsql-patches(at)postgresql(dot)org
Subject: Re: [HACKERS] Autovacuum loose ends
Date: 2005-07-30 14:55:33
Message-ID: 26777.1122735333@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
>>> I think you should at least add an autovacuum specific value for 
>>> "vacuum_cost_delay" because it turns cost-based vacuum delay on or off.

> I am thinking we should move ahead with what we have now, suggest the
> work-arounds, and thensee what use-cases we have for it for later
> releases.

I think it's absolutely unquestionable that there is a use-case for
running autovac with different vacuum-delay settings than you would
want to apply to manually issued vacuums.  We don't need to wait for
field experience on that one; we already have it with the contrib
version.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2005-07-30 14:57:15
Subject: Re: [HACKERS] Autovacuum loose ends
Previous:From: Bruce MomjianDate: 2005-07-30 14:53:20
Subject: Re: Updated open items

pgsql-patches by date

Next:From: Bruce MomjianDate: 2005-07-30 14:57:15
Subject: Re: [HACKERS] Autovacuum loose ends
Previous:From: Bruce MomjianDate: 2005-07-30 14:52:02
Subject: Re: Interval->day docs and regression tests

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