Re: postgresql 8.3 tps rate

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 1/23/09, Ibrahim Harrani <ibrahim.harrani@xxxxxxxxx> 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

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux