Re: Slow count(*) again...

Поиск
Список
Период
Сортировка
От Jon Nelson
Тема Re: Slow count(*) again...
Дата
Msg-id AANLkTi=gbaApWtgDEwH0A_tyjVroqMzaGEaqvjPKpCpO@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Slow count(*) again...  (Mladen Gogala <mladen.gogala@vmsinfo.com>)
Список 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 по дате отправления:

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: Slow count(*) again...
Следующее
От: Joshua Tolley
Дата:
Сообщение: Re: Slow count(*) again...