Re: [PERFORM] seq scan cache vs. index cache smackdown

[Iain]

Hi Rod,
 
> Any solution fixing buffers should probably not take into consideration
> the method being performed (do you really want to skip caching a
> sequential scan of a 2 tuple table because it didn't use an index) but
> the volume of data involved as compared to the size of the cache.

Yes, in fact indexes aren't so different to tables really in that regard.

It sounds like version 8 may help out anyway.

regards
Iain

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings