Re: Query Performance Test

From: Scott Ribe <scott_ribe(at)killerbytes(dot)com>
To: dcrespo <dcrespo(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Query Performance Test
Date: 2007-11-19 03:46:24
Message-ID: C3665520.863AF%scott_ribe@killerbytes.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> So, how can I do to execute it as if it was the first
> time again?

Reboot.

As Lew pointed out, that might not actually be a good idea, because caching
means that most queries will most of the time not run with that "first time"
performance.

--
Scott Ribe
scott_ribe(at)killerbytes(dot)com
http://www.killerbytes.com/
(303) 722-0567 voice

In response to

Browse pgsql-general by date

  From Date Subject
Next Message rkmr.em@gmail.com 2007-11-19 03:52:45 unable to createuser in postgres 8.2.5 opensolaris
Previous Message brian 2007-11-19 03:11:28 Re: getting the number of rows affected by a query