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

From Merlin Moncure
Subject Re: postgresql 8.3 tps rate
Date
Msg-id b42b73150901230651j50365334u2794c9bfdfc69027@mail.gmail.com
Whole thread Raw
In response to Re: postgresql 8.3 tps rate  (Ibrahim Harrani <ibrahim.harrani@gmail.com>)
Responses Re: postgresql 8.3 tps rate
List pgsql-performance
On 1/23/09, 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)

Note, while sequential write speeds are a good indication of general
raid crappyness, they are not the main driver of your low pgbench
results (buy they may be involved with poor insert performance)

That is coming from your seek performance, which is also lousy at ~130
according to bonnie.

merlin

pgsql-performance by date:

Previous
From: Florian Weimer
Date:
Subject: Re: SSD performance
Next
From: Merlin Moncure
Date:
Subject: Re: SSD performance