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

From Russell Smith
Subject Re: Heavy write activity on first vacuum of fresh TOAST data
Date
Msg-id 47623103.7030700@pws.com.au
Whole thread Raw
In response to Re: Heavy write activity on first vacuum of fresh TOAST data  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Heavy write activity on first vacuum of fresh TOAST data
List pgsql-performance
Simon Riggs wrote:
> On Thu, 2007-12-13 at 15:19 -0600, Kevin Grittner wrote:
>
>> What impact would lack of the hint bits have until a vacuum?
>>
>
> Vacuum isn't important here. Its the first idiot to read the data that
> gets hit.
>
>
Given vacuum must then touch every page, is there a win in only setting
hint bits on pages where vacuum has to do some other work on the page?
As vacuum is causing significant IO load for data that may not be
accessed for some time.

The question becomes what is the impact of not setting hint bits?  Is it
better or worse than the IO caused by vacuum?

Regards

Russell Smith

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Heavy write activity on first vacuum of fresh TOAST data
Next
From: Tom Lane
Date:
Subject: Re: Heavy write activity on first vacuum of fresh TOAST data