| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Alex Deucher <alexdeucher(at)gmail(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 02:21:36 |
| Message-ID: | 45E78A30.1030408@commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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).
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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alex Deucher | 2007-03-02 03:16:37 | Re: strange performance regression between 7.4 and 8.1 |
| Previous Message | Alex Deucher | 2007-03-02 02:06:54 | Re: strange performance regression between 7.4 and 8.1 |