Re: postgresql 8.3 tps rate

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Ibrahim Harrani <ibrahim(dot)harrani(at)gmail(dot)com>
Cc: Craig James <craig_james(at)emolecules(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: postgresql 8.3 tps rate
Date: 2009-01-23 08:42:56
Message-ID: dcc563d10901230042s370f8013q65a987f8e85adc5b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Jan 22, 2009 at 10:52 PM, Ibrahim Harrani
<ibrahim(dot)harrani(at)gmail(dot)com> wrote:
> Hi Craig,
>
> Here is the result. It seems that disk write is terrible!.
>
> root(at)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?

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Glyn Astill 2009-01-23 11:12:18 Re: SSD performance
Previous Message Craig James 2009-01-23 06:35:24 Re: postgresql 8.3 tps rate