Re: Bug: Buffer cache is not scan resistant

On Mon, 2007-03-05 at 15:30 -0500, Tom Lane wrote:
> Jeff Davis  writes:
> > Absolutely. I've got a parameter in my patch "sync_scan_offset" that
> > starts a seq scan N pages before the position of the last seq scan
> > running on that table (or a current seq scan if there's still a scan
> > going). 
> 
> Strikes me that expressing that parameter as a percentage of
> shared_buffers might make it less in need of manual tuning ...
> 

The original patch was a percentage of effective_cache_size, because in
theory it may be helpful to have this parameter larger than shared
buffers. Synchronized Scannning can take advantage of OS buffer cache as
well.

Someone convinced me to change it to be an independent variable.

I don't have a strong opinion, but now I have three different opinions:
(1) Independent parameter
(2) Percentage of shared_buffers
(3) Percentage of effective_cache_size

Regards,Jeff Davis