Re: Testing query times

On Thu, Dec 3, 2009 at 2:55 PM, Christine Penner
<christine@ingenioussoftware.com> wrote:
> Hi,
>
> The first time I use a query its much slower than the second, third etc. I
> want to do some testing with the 1st (slower) time. The only way I have
> found to reproduce that slow time is to restart my computer which is a huge
> pain. Is there a better way to clear whatever Postgres is holding to make
> them faster. I have tried restarting the Postgres service but that doesn't
> help.

Restarting pgsql accomplishes the same thing as regards pgsql.  BUT
most OSes also cache, so you need a way to flush the kernel / file
system cache.  That depends on which OS you're running.