Re: postgresql 8.3 tps rate - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: postgresql 8.3 tps rate
Date
Msg-id dcc563d10901230042s370f8013q65a987f8e85adc5b@mail.gmail.com
Whole thread Raw
In response to Re: postgresql 8.3 tps rate  (Ibrahim Harrani <ibrahim.harrani@gmail.com>)
List pgsql-performance
On Thu, Jan 22, 2009 at 10:52 PM, Ibrahim Harrani
<ibrahim.harrani@gmail.com> wrote:
> Hi Craig,
>
> Here is the result. It seems that disk write is terrible!.
>
> root@myserver /usr]#  time (dd if=/dev/zero of=bigfile bs=8192
> count=1000000; sync)
>
>
> 1000000+0 records in
> 1000000+0 records out
> 8192000000 bytes transferred in 945.343806 secs (8665630 bytes/sec)

That's pretty horrific.  Can you try your disks without the
motherboard RAID controller in the way either singly or using software
RAID?

pgsql-performance by date:

Previous
From: Craig James
Date:
Subject: Re: postgresql 8.3 tps rate
Next
From: david@lang.hm
Date:
Subject: SSD performance