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

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 (view raw or flat)
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

pgsql-hackers by date

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

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