>>> On Fri, Dec 14, 2007 at 1:42 AM, in message <29185(dot)1197618162(at)sss(dot)pgh(dot)pa(dot)us>,
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> My feeling is that vacuum's purpose in life is to offload maintenance
> cycles from foreground queries, so we should be happy to have it setting
> all the hint bits.
> If Kevin doesn't like the resultant I/O load then he
> should use the vacuum_cost_delay parameters to dial down vacuum speed.
It's not that I don't like it -- I'm often called upon to diagnose
issues, and understanding the dynamics of things like this helps me
interpret what I'm seeing. No complaint here.
In response to
pgsql-performance by date
|Next:||From: Bill Moran||Date: 2007-12-14 15:25:26|
|Subject: Re: viewing source code|
|Previous:||From: Roberts, Jon||Date: 2007-12-14 15:01:09|
|Subject: viewing source code|