Query timing stable?

From: Cheng <niechenghust(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Query timing stable?
Date: 2012-03-14 18:24:42
Message-ID: 4F60E26A.3030804@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message ktm@rice.edu 2012-03-14 18:30:58 Re: Query timing stable?
Previous Message Rory Campbell-Lange 2012-03-13 23:01:01 Re: QUERY