Re: strange performance regression between 7.4 and 8.1 - Mailing list pgsql-performance

From Alex Deucher
Subject Re: strange performance regression between 7.4 and 8.1
Date
Msg-id a728f9f90703011916x17f40884qdb90dd21946154d4@mail.gmail.com
Whole thread Raw
In response to Re: strange performance regression between 7.4 and 8.1  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-performance
On 3/1/07, Joshua D. Drake <jd@commandprompt.com> wrote:
> Alex Deucher wrote:
> > On 3/1/07, Joshua D. Drake <jd@commandprompt.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
> >
>

pgsql-performance by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: strange performance regression between 7.4 and 8.1
Next
From: David Leangen
Date:
Subject: Improving query performance