Re: Benchmarking a large server

Поиск
Список
Период
Сортировка
От Claudio Freire
Тема Re: Benchmarking a large server
Дата
Msg-id BANLkTimsRfJ-q8vWtGq-WD2ciAxuE3UWKQ@mail.gmail.com
обсуждение исходный текст
Ответ на Benchmarking a large server  (Chris Hoover <revoohc@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Sethu Prasad
Дата:
Сообщение: Re: Postgres 9.0.4 + Hot Standby + FusionIO Drive + Performance => Query failed ERROR: catalog is missing 1 attribute(s) for relid 172226
Следующее
От: Thomas Hägi
Дата:
Сообщение: Re: indexes ignored when querying the master table