Re: RFC: changing autovacuum_naptime semantics - Mailing list pgsql-hackers

From Grzegorz Jaskiewicz
Subject Re: RFC: changing autovacuum_naptime semantics
Date
Msg-id 71005F96-3B72-496E-A3A7-FEAC0E542CBB@pointblue.com.pl
Whole thread Raw
In response to Re: RFC: changing autovacuum_naptime semantics  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Mar 9, 2007, at 6:42 AM, Tom Lane wrote:

> Alvaro Herrera <alvherre@commandprompt.com> writes:
>> Now regarding your restartable vacuum work.  I think that stopping a
>> vacuum at some point and being able to restart it later is very  
>> cool and
>> may get you some hot chicks, but I'm not sure it's really useful.
>
> Too true :-(

Yeah.
Wouldn't 'divide and conquer' kinda approach make it better ? Ie. let  
vacuum to work on some part of table/db. Than stop, pick up another  
part later, vacuum it, etc, etc ?

-- 
Grzegorz Jaskiewicz
gj@pointblue.com.pl





pgsql-hackers by date:

Previous
From: August Zajonc
Date:
Subject: Re: Acclerating INSERT/UPDATE using UPS
Next
From: "Zeugswetter Andreas ADI SD"
Date:
Subject: Re: Auto creation of Partitions