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

From Cédric Villemain
Subject Re: Benchmarking a large server
Date
Msg-id BANLkTikecJCGWH0WyKFiSnC08kmcwS7FqA@mail.gmail.com
Whole thread Raw
In response to Benchmarking a large server  (Chris Hoover <revoohc@gmail.com>)
Responses Re: Benchmarking a large server
List pgsql-performance
2011/5/9 Chris Hoover <revoohc@gmail.com>:
> I've got a fun problem.
> My employer just purchased some new db servers that are very large.  The
> specs on them are:
> 4 Intel X7550 CPU's (32 physical cores, HT turned off)
> 1 TB Ram
> 1.3 TB Fusion IO (2 1.3 TB Fusion IO Duo cards in a raid 10)
> 3TB Sas Array (48 15K 146GB spindles)
> The issue we are running into is how do we benchmark this server,
> specifically, how do we get valid benchmarks for the Fusion IO card?
>  Normally to eliminate the cache effect, you run iozone and other benchmark
> suites at 2x the ram.  However, we can't do that due to 2TB > 1.3TB.
> So, does anyone have any suggestions/experiences in benchmarking storage
> when the storage is smaller then 2x memory?

You can reduce the memory size on server boot.
If you use linux, you can add a 'mem=512G' to your boot time
parameters. (maybe it supports only K or M, so 512*1024...)

> Thanks,
> Chris



--
Cédric Villemain               2ndQuadrant
http://2ndQuadrant.fr/     PostgreSQL : Expertise, Formation et Support

pgsql-performance by date:

Previous
From: Josh Berkus
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: Craig James
Date:
Subject: Re: Benchmarking a large server