Re: Slow count(*) again... - Mailing list pgsql-performance

From Jon Nelson
Subject Re: Slow count(*) again...
Date
Msg-id AANLkTi=gbaApWtgDEwH0A_tyjVroqMzaGEaqvjPKpCpO@mail.gmail.com
Whole thread Raw
In response to Re: Slow count(*) again...  (Mladen Gogala <mladen.gogala@vmsinfo.com>)
List pgsql-performance
On Sun, Oct 10, 2010 at 12:14 PM, Mladen Gogala
<mladen.gogala@vmsinfo.com> 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

pgsql-performance by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Slow count(*) again...
Next
From: Joshua Tolley
Date:
Subject: Re: Slow count(*) again...