Jon Nelson <jnelson+pgsql@jamponi.net> wrote:
> Greg Smith <greg@2ndquadrant.com> wrote:
>> Usually the sequence used to remove all cached data from RAM
>> before a benchmark is:
>
> All cached data (as cached in postgresql - *not* the Linux system
> caches)..., right?
No. The stop and start of PostgreSQL causes empty PostgreSQL
caches. These lines, in between the stop and start, force the Linux
cache to be empty (on recent kernel versions):
sync
echo 3 > /proc/sys/vm/drop_caches
-Kevin