Re: Deadline-Based Vacuum Delay

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Galy Lee <lee(dot)galy(at)oss(dot)ntt(dot)co(dot)jp>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Deadline-Based Vacuum Delay
Date: 2006-12-28 15:01:25
Message-ID: 6980.1167318085@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Galy Lee <lee(dot)galy(at)oss(dot)ntt(dot)co(dot)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.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-12-28 15:24:54 Re: Recent SIGSEGV failures in buildfarm HEAD
Previous Message Jie Zhang 2006-12-28 14:37:34 Re: Bitmap index thoughts