Re: Server Performance - Mailing list pgsql-general

From Greg Smith
Subject Re: Server Performance
Date
Msg-id alpine.GSO.2.01.0903311638390.8042@westnet.com
Whole thread Raw
In response to Server Performance  (Chris.Ellis@shropshire.gov.uk)
List pgsql-general
On Tue, 31 Mar 2009, Chris.Ellis@shropshire.gov.uk wrote:

> Been having interesting times with an IBM x3650 with 8 15k RPM 73GB
> drives in RAID 10 and a ServRAID 8K controller with Write-Back cache
> enabled (battery installed and working).  Currently getting a pgbench
> score of 4.7 transactions per second!

pgbench is a very high level test of your system.  It can tell you when a
system is doing well, but it's almost useless for figuring out what's
wrong if there's a problem.

You shouldn't run pgbench until you've first done a lower-level benchmark
such as bonnie++ on the hardware.  That should give you a better idea
what's going on here, and if the badness shows up there it will be much
easier to get someone at IBM to pay attention too.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

pgsql-general by date:

Previous
From: Laurent Rahuel
Date:
Subject: Triggers for a MPTT based table
Next
From: Patrick Desjardins
Date:
Subject: ERROR: XX001: could not read block 2354 of relation…