Re: strange performance regression between 7.4 and 8.1

From: "Alex Deucher" <alexdeucher(at)gmail(dot)com>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: "Jeff Frost" <jeff(at)frostconsultingllc(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: strange performance regression between 7.4 and 8.1
Date: 2007-03-02 03:16:37
Message-ID: a728f9f90703011916x17f40884qdb90dd21946154d4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 3/1/07, Joshua D. Drake <jd(at)commandprompt(dot)com> wrote:
> Alex Deucher wrote:
> > On 3/1/07, Joshua D. Drake <jd(at)commandprompt(dot)com> wrote:
> >> \
> >> >> Is the SAN being shared between the database servers and other
> >> >> servers? Maybe
> >> >> it was just random timing that gave you the poor write performance on
> >> >> the old
> >> >> server which might be also yielding occassional poor performance on
> >> >> the new
> >> >> one.
> >> >>
> >> >
> >> > The direct attached scsi discs on the old database server we getting
> >> > 45MBps not the SAN. The SAN got 62/145Mbps, which is not as bad.
> >>
> >> How many spindles you got in that SAN?
> >
> > 105 IIRC.
>
> You have 105 spindles are you are only get 62megs on writes? That seems
> about half what you should be getting. (at least).
>

Take the numbers with grain of salt. They are by no means a thorough
evaluation. I just ran bonnie a couple times to get a rough reference
point. I can do a more thorough analysis.

Alex

> Joshua D. Drake
>
>
> >
> > Alex
> >
>

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Adam L Beberg 2007-03-02 03:59:04 Array indexes, GIN?
Previous Message Joshua D. Drake 2007-03-02 02:21:36 Re: strange performance regression between 7.4 and 8.1