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