Re: Heavy write activity on first vacuum of fresh TOAST data - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: Heavy write activity on first vacuum of fresh TOAST data
Date
Msg-id 47624A8E.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Re: Heavy write activity on first vacuum of fresh TOAST data  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
>>> On Fri, Dec 14, 2007 at  1:42 AM, in message <29185.1197618162@sss.pgh.pa.us>,
Tom Lane <tgl@sss.pgh.pa.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.

Absolutely.

> 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.

-Kevin




pgsql-performance by date:

Previous
From: "Roberts, Jon"
Date:
Subject: viewing source code
Next
From: Bill Moran
Date:
Subject: Re: viewing source code