Re: Testing query times

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@2ndQuadrant.com  www.2ndQuadrant.com