Re: Benchmarking a large server - Mailing list pgsql-performance

From Claudio Freire
Subject Re: Benchmarking a large server
Date
Msg-id BANLkTimsRfJ-q8vWtGq-WD2ciAxuE3UWKQ@mail.gmail.com
Whole thread Raw
In response to Benchmarking a large server  (Chris Hoover <revoohc@gmail.com>)
List pgsql-performance
On Mon, May 9, 2011 at 10:32 PM, Chris Hoover <revoohc@gmail.com> 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.

pgsql-performance by date:

Previous
From: Sethu Prasad
Date:
Subject: Re: Postgres 9.0.4 + Hot Standby + FusionIO Drive + Performance => Query failed ERROR: catalog is missing 1 attribute(s) for relid 172226
Next
From: Thomas Hägi
Date:
Subject: Re: indexes ignored when querying the master table