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

[Russell Smith <mr-russ(at)pws(dot)com(dot)au>]

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