Testing query times - Mailing list pgsql-general

From Christine Penner
Subject Testing query times
Date
Msg-id 806sno$5i1571@pd7mo1no-svcs.prod.shaw.ca
Whole thread Raw
Responses Re: Testing query times  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
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.

Christine Penner
Ingenious Software
250-352-9495
christine@ingenioussoftware.com


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: code example for PQgetCopyData
Next
From: Scott Marlowe
Date:
Subject: Re: Testing query times