Tom Lane wrote:
I think the context for this is that you have an agreed-on maintenance
window, say extending from 2AM to 6AM local time, and you want to get
all your vacuuming done in that window without undue spikes in the
system load (because you do still have live users then, just not as
Galy Lee [EMAIL PROTECTED] writes:
It is true that there is not a decent way to estimate the amount of work
to be done. But the purpose in here is not âspread the vacuum over 6
hours exactlyâ, it is âfinish vacuum within 6 hours, and spread the
spikes as much as possibleâ. So the
On Dec 29, 2006, at 12:30 PM, Chris Browne wrote:
How you get the work to spread consistently across 6 hours is a
challenge; personally, my preference would generally be to try to get
the work done ASAP, so the goal seems a tad off to me...
Agreed. If we're going to monkey with automatically
[EMAIL PROTECTED] (Jaime Casanova) writes:
On 12/28/06, Tom Lane [EMAIL PROTECTED] wrote:
Galy Lee [EMAIL PROTECTED] 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
On 12/29/06, Chris Browne [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] (Jaime Casanova) writes:
On 12/28/06, Tom Lane [EMAIL PROTECTED] wrote:
Galy Lee [EMAIL PROTECTED] writes:
So I am thinking another way to perform vacuum. For example vacuum can
be refined in a maintenance time frame like
Chris Browne [EMAIL PROTECTED] writes:
How you get the work to spread consistently across 6 hours is a
challenge; personally, my preference would generally be to try to get
the work done ASAP, so the goal seems a tad off to me...
I think the context for this is that you have an agreed-on
Galy Lee [EMAIL PROTECTED] 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
On 12/28/06, Tom Lane [EMAIL PROTECTED] wrote:
Galy Lee [EMAIL PROTECTED] 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
Hello,
I'd like to propose a new feature, Deadline-Based Vacuum Delay, the
syntax is something like VACUUM IN 6 HOURS.
Vacuum is a non-trivial task to be performed. The database needs to be
vacuumed before the system performance suffers from the garbage; it also
needs to ensure the system won't