Scott Marlowe wrote:
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: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. sync; echo 3 > /proc/sys/vm/drop_cachesAnd 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@xxxxxxxxxxxxxxx www.2ndQuadrant.com |
