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: (view raw, whole thread or download thread mbox)
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.


In response to


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-2017 The PostgreSQL Global Development Group