Re: Deadline-Based Vacuum Delay - Mailing list pgsql-hackers

From Jaime Casanova
Subject Re: Deadline-Based Vacuum Delay
Date
Msg-id c2d9e70e0612281627p67a5bebeu953905ba13a765af@mail.gmail.com
Whole thread Raw
In response to Re: Deadline-Based Vacuum Delay  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 12/28/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Galy Lee <lee.galy@oss.ntt.co.jp> writes:
> > So I am thinking another way to perform vacuum. For example vacuum can
> > be refined in a maintenance time frame like "VACUUM IN 6 HOURS", and
> > then vacuum operation will be performed within the window. The delay
> > time is adjusted internally to spread the disk I/O over the time frame.
>
> And you will manage that how?  The total amount of work to be done is
> quite unpredictable.
>

specially for something you already can do with cron (*nix) or job
scheduler (windows)

-- 
regards,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."                                      Richard Cook


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Strange pgsql crash on MacOSX
Next
From: Stephen Frost
Date:
Subject: Re: TODO: GNU TLS