Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Merlin MoncureDate: 2009-01-23 14:59:46
Subject: Re: SSD performance
Previous:From: Florian WeimerDate: 2009-01-23 14:30:26
Subject: Re: SSD performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group