"Magnus Hagander" <[EMAIL PROTECTED]> writes: > What about the cache memory on the disk? Even IDE disks have some 8Mb > cache today, which makes a lot of difference for fairly short scans. > Even if it's just read cache. That'll bring the speed of random access > down to a 1=1 relationship with sequential access, assuming all fits in > the cache.
8MB cache is really insignificant compared to the hundreds or thousands of megabytes the OS would be using to cache. You could just add the 8MB to your effective_cache_size (except it's not really 100% effective since it would contain some of the same blocks as the OS cache). -- greg ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings