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
> >
>
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 |