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

From Joshua D. Drake
Subject Re: strange performance regression between 7.4 and 8.1
Date
Msg-id 45E78A30.1030408@commandprompt.com
Whole thread Raw
In response to Re: strange performance regression between 7.4 and 8.1  ("Alex Deucher" <alexdeucher@gmail.com>)
Responses Re: strange performance regression between 7.4 and 8.1  ("Alex Deucher" <alexdeucher@gmail.com>)
List pgsql-performance
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).

Joshua D. Drake


>
> Alex
>


--

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


pgsql-performance by date:

Previous
From: "Alex Deucher"
Date:
Subject: Re: strange performance regression between 7.4 and 8.1
Next
From: "Alex Deucher"
Date:
Subject: Re: strange performance regression between 7.4 and 8.1