On Mon, May 9, 2011 at 10:32 PM, Chris Hoover <revoohc@xxxxxxxxx> wrote: > So, does anyone have any suggestions/experiences in benchmarking storage > when the storage is smaller then 2x memory? Try writing a small python script (or C program) to mmap a large chunk of memory, with MAP_LOCKED, this will keep it in RAM and avoid that RAM from being used for caching. The script should touch the memory at least once to avoid overcommit from getting smart on you. I think only root can lock memory, so that small program would have to run as root. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
