Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Server Performance
- From: Greg Smith <gsmith(at)gregsmith(dot)com>
- To: Chris(dot)Ellis(at)shropshire(dot)gov(dot)uk
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: Server Performance
- Date: Tue, 31 Mar 2009 16:42:08 -0400 (EDT)
- Message-id: <alpine.GSO.2.01.0903311638390.8042@westnet.com> <text/plain>
On Tue, 31 Mar 2009, Chris(dot)Ellis(at)shropshire(dot)gov(dot)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(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD
- References:
- Server Performance
- From: Chris . Ellis
- Server Performance
- Prev by Date: ERROR: XX001: could not read block 2354 of relation …
- Next by Date: Re: Space for pg_dump
- Previous by thread: Re: Server Performance
- Next by thread: Postgres: Packaging & Server Startup
- Indexes: