Re: Can anyone explain this pgbench results?

From: "Joost Kraaijeveld" <J(dot)Kraaijeveld(at)Askesis(dot)nl>
To: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
Cc: "Pgsql-Performance (E-mail)" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Can anyone explain this pgbench results?
Date: 2006-03-07 19:49:30
Message-ID: A3D1526C98B7C1409A687E0943EAC410605FC8@obelix.askesis.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


Jim C. Nasby wrote:

> Speaking of 'disks', what's your exact layout? Do you have a 5 drive
> raid5 for the OS and the database, 1 drive for swap and 1 drive for
> pg_xlog?

On a Sil SATA 3114 controller:
/dev/sda OS + Swap
/dev/sdb /var with pg_xlog

On the 3Ware 9500S-8, 5 disk array:
/dev/sdc with the database (and very safe, my MP3 collection ;-))

As I wrote in one of my posts to Michael, I suspect that the card is not handling the amount of write operations as well as I expected. I wonder if anyone else sees the same characteristics with this kind of card.

Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J(dot)Kraaijeveld(at)Askesis(dot)nl
web: www.askesis.nl

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2006-03-07 19:56:45 Re: firebird X postgresql 8.1.2 windows, performance
Previous Message Tom Lane 2006-03-07 19:36:56 Re: pg_reset_stats + cache I/O %