Re: Interesting incosistent query timing

Поиск
Список
Период
Сортировка
От Manfred Koizar
Тема Re: Interesting incosistent query timing
Дата
Msg-id bdlsev4mqcikl2on1ptqta5ic1mk39p4e4@4ax.com
обсуждение исходный текст
Ответ на Interesting incosistent query timing  (Ernest E Vogelsinger <ernest@vogelsinger.at>)
Список pgsql-general
On Tue, 17 Jun 2003 00:46:54 +0200, Ernest E Vogelsinger
<ernest@vogelsinger.at> wrote:
>For the first time run it executes in 1.5 - 2 seconds. From the second
>time, only 10 msec are needed for the same result

I'd call it inconsistent, if it were the other way round :-)  I guess
you are seeing the effects of disk caching.  Watch the drive LED
during the first run ...

Servus
 Manfred

В списке pgsql-general по дате отправления:

Предыдущее
От: Ernest E Vogelsinger
Дата:
Сообщение: Re: Postgres performance comments from a MySQL user
Следующее
От: Rory Campbell-Lange
Дата:
Сообщение: Re: Can I do of in one call?