On Sun, Oct 10, 2010 at 12:14 PM, Mladen Gogala <mladen.gogala@xxxxxxxxxxx> wrote: > > > > In other words, when I batched the sequential scan to do 128 blocks I/O, it > was 4 times faster than when I did the single block I/O. > Does that provide enough of an evidence and, if not, why not? These numbers tell us nothing because, unless you dropped the caches between runs, then at least part of some runs was very probably cached. -- Jon -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
