Query timing stable?

Поиск
Список
Период
Сортировка
От Cheng
Тема Query timing stable?
Дата
Msg-id 4F60E26A.3030804@gmail.com
обсуждение исходный текст
Ответы Re: Query timing stable?  ("ktm@rice.edu" <ktm@rice.edu>)
Re: Query timing stable?  (Steve Crawford <scrawford@pinpointresearch.com>)
Список pgsql-novice
Hi,

I turned on "\timing" in the command line. It seems that the timing is
not stable. For the same query, the query's executing time is longer for
the first time I run it than for the second and third time run it. I
think it might be "cached" automatically.

Is there a way to turn the "automatic caching" off so that I can get the
same "timing" when I run the same query? Or is there some other way to
get stable query time whenever the query is run?

Thanks,
Cheng

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

Предыдущее
От: Rory Campbell-Lange
Дата:
Сообщение: Re: QUERY
Следующее
От: "ktm@rice.edu"
Дата:
Сообщение: Re: Query timing stable?