Re: postgresql 8.3 tps rate

From: Merlin Moncure <mmoncure(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 14:51:20
Message-ID: b42b73150901230651j50365334u2794c9bfdfc69027@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 1/23/09, 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)

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2009-01-23 14:59:46 Re: SSD performance
Previous Message Florian Weimer 2009-01-23 14:30:26 Re: SSD performance