Re: Server Performance

From: Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
To: Chris(dot)Ellis(at)shropshire(dot)gov(dot)uk
Cc: pgsql-general(at)postgresql(dot)org, scott(dot)marlowe(at)gmail(dot)com
Subject: Re: Server Performance
Date: 2009-04-01 20:01:06
Message-ID: 49D3C802.3010109@kaltenbrunner.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Chris(dot)Ellis(at)shropshire(dot)gov(dot)uk wrote:
>
> Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc> wrote on 01/04/2009 06:53:07:
>
> > Chris(dot)Ellis(at)shropshire(dot)gov(dot)uk wrote:
> > >
> > > Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote on 31/03/2009 15:53:34:
> > >
> > > > On Tue, Mar 31, 2009 at 8:21 AM,
> <Chris(dot)Ellis(at)shropshire(dot)gov(dot)uk> wrote:
> > > > >
> > > > > Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote on 31/03/2009
> 15:16:01:
> > > > >
> > > > >> I'd call IBM and ask them to come pick up their boat anchors.
> > > > >
> > > > > My sentiments exactly, unfortunately, I seem stuck with them :(
> > > >
> > > > Can you at least source your own RAID controllers?
> > >
> > > Yes I will be, I never really did trust IBM and I certainly don't now!
> > >
> > > I just need to choose the correct RAID card now, good performance
> at the
> > > right price.
> >
> > you are jumping to conclusions too quickly - while the 8k is not the
> > worlds fastest raid card available it is really not (that) bad at all.
> > we have plenty of x3650 in production and last time I tested I was
> > easily able to get >>2000tps even on an untuned postgresql install and
> > with fwer disks.
>
> Could you provide any more information upon your configurations if
> possible, please?

x3650, dual quadcore Xeon 5430. Servraid 8k with 256MB-BBWC and likely
RAID6 during that testing. OS was/is debian etch/amd64. Don't have the
exact (pgbench) test parameters handy anymore though...

>
> >
> > So I really think you are looking at another problem here (be it
> > defective hardware or a driver/OS level issue).
>
> Hardware is always a possiblity, finally managed to get hold of IBM too.
> I have tried two different Linux distro's, with different kernels, My
> current Mandriva test using a fairly upto date kernel.
> I may try a custom kernel.

also test with different IO schedulers(especially deadline and noop).

Stefan

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Diego Schulz 2009-04-01 20:03:51 Re: Installed PG with pgAdmin, some days later, now my password don't work!
Previous Message Raymond O'Donnell 2009-04-01 19:58:04 Re: Installed PG with pgAdmin, some days later, now my password don't work!