Query timing stable? - Mailing list pgsql-novice

From Cheng
Subject Query timing stable?
Date
Msg-id 4F60E26A.3030804@gmail.com
Whole thread Raw
Responses Re: Query timing stable?  ("ktm@rice.edu" <ktm@rice.edu>)
Re: Query timing stable?  (Steve Crawford <scrawford@pinpointresearch.com>)
List 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 by date:

Previous
From: Rory Campbell-Lange
Date:
Subject: Re: QUERY
Next
From: "ktm@rice.edu"
Date:
Subject: Re: Query timing stable?