Re: Server Performance - Mailing list pgsql-general
| From | Chris.Ellis@shropshire.gov.uk |
|---|---|
| Subject | Re: Server Performance |
| Date | |
| Msg-id | OFD5901EF4.F05CDAB3-ON8025758A.004EADB1-8025758A.004F0D83@shropshire.gov.uk Whole thread Raw |
| In response to | Re: Server Performance (Scott Marlowe <scott.marlowe@gmail.com>) |
| Responses |
Re: Server Performance
(Scott Marlowe <scott.marlowe@gmail.com>)
|
| List | pgsql-general |
Scott Marlowe <scott.marlowe@gmail.com> wrote on 31/03/2009 15:16:01:
> On Tue, Mar 31, 2009 at 3:37 AM, <Chris.Ellis@shropshire.gov.uk> wrote:
> >
> > Hi
> >
> > 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! After playing with the postgresql configuration
> > file, I'm certain that this is not a postgresql problem. I have tried two
> > different Linux distro's upon the server both with the same problems. I'm
> > fairly certain that this is a problem with the hardware configuration /
> > setup, however I'm still waiting for IBM to contact me!
> >
> > Initially I started with the OS on a RAID 1 array and a 6 drive RAID 10
> > array for postgresql. With this setup I got 3tps, altering the RAID
> > configuration to a single 8 drive array, running both the OS and postgresql.
> > I was able to reach 700tps, however after upgrading to the latest RAID
> > controller firmware this has now fallen back to 4tps.
> >
> > Benchmarking another server I have access to, 4 15k 73GB RPM disks with a
> > Dell Perc 5/i controller. I consistently get a pgbench score of 1400tps.
> > Therefore taking a linear extrapolation I expect the IBM x3650 to manage
> > ~3000tps. Additionally my Laptop with a 5400 RPM sata disk was able to
> > score ~200tps.
>
> SNIP
>
> > What SAS RAID controllers are people using?
> >
> > What RAID configurations are people using?
> >
> > What SAS RAID controllers would anyone recommend purchasing?
>
> I am using an Areca 1680 series controller. 16 SAS 15k5 disks. 2
> RAID-1, 12 RAID-10, 2 hot spares. 512Meg bbu. RHEL 5.2 I can sustain
> around 3000 tps with pgbench and 30 minute runs.
Thanks for the Info.
>
> I'd call IBM and ask them to come pick up their boat anchors.
My sentiments exactly, unfortunately, I seem stuck with them :(
Chris Ellis
******************************************************************************
If you are not the intended recipient of this email please do not send it on
to others, open any attachments or file the email locally.
Please inform the sender of the error and then delete the original email.
For more information, please refer to http://www.shropshire.gov.uk/privacy.nsf
******************************************************************************
pgsql-general by date: