| From: | Greg Smith <greg(at)2ndquadrant(dot)com> |
|---|---|
| To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | Christine Penner <christine(at)ingenioussoftware(dot)com>, Postgres-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Testing query times |
| Date: | 2009-12-03 22:19:01 |
| Message-ID: | 4B183955.9070503@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Scott Marlowe wrote:
> 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.
>
Can't tell if this is Linux or Windows from how the question was asked.
Here's how to clear the OS cache on Linux:
|sync; echo 3 > /proc/sys/vm/drop_caches|
And on Windows you should be able to clear it with CacheSet:
http://technet.microsoft.com/en-us/sysinternals/bb897561.aspx
--
Greg Smith 2ndQuadrant Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com www.2ndQuadrant.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2009-12-03 23:41:08 | Re: Strange. I can logon with an invalid or no password atall |
| Previous Message | Scott Marlowe | 2009-12-03 22:14:33 | Re: Testing query times |