| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Christine Penner <christine(at)ingenioussoftware(dot)com> |
| Cc: | Postgres-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Testing query times |
| Date: | 2009-12-03 22:14:33 |
| Message-ID: | dcc563d10912031414s2eec39dco22330d20c456164e@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Dec 3, 2009 at 2:55 PM, Christine Penner
<christine(at)ingenioussoftware(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Smith | 2009-12-03 22:19:01 | Re: Testing query times |
| Previous Message | Christine Penner | 2009-12-03 21:55:51 | Testing query times |