Re: Deadline-Based Vacuum Delay
От | Jaime Casanova |
---|---|
Тема | Re: Deadline-Based Vacuum Delay |
Дата | |
Msg-id | c2d9e70e0612281627p67a5bebeu953905ba13a765af@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Deadline-Based Vacuum Delay (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | 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 по дате отправления: