View Single Post

   
  #7 (permalink)  
Old 04-18-2008, 11:08 AM
Iain
 
Posts: n/a
Default Re: seq scan cache vs. index cache smackdown

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

Reply With Quote