Re: Heavy write activity on first vacuum of fresh TOAST data

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