From: Daniel Ferreira de Lima <dfl.man@gmail.com>
To: pgsql-performance@postgresql.org
Subject: IDE x SAS RAID 0 on HP DL 380 G5 P400i controller performance problem
Date: Mon, 19 Jul 2010 09:24:01 -0300
Message-ID: <AANLkTimtyqefnmOF6xEihmoSjD333yGuYXRQ4PyVXe6j@mail.gmail.com> (raw)
Hi people,
I have a particular performance problem under a system installed.
In the lab I have an old Microside + Dual Core machine 1GB RAM with 40gb HD
IDE and
a newer machine HP DL 380 G5 4GB RAM and 500GB SAS under RAID 0 (4 disks)
P400i Smart Array Controller.
**Both with Linux Kernel 2 .4.37.9 and Postgresql 7.2**
Under a insertion test we get a performance of 2.5 secs under 2000 inserts
(table with a single char(50) column) in the IDE disk.
And 500GB RAID 0 (4 disks!) and 37.5 secs under the same test!
I tried:
- All the postgresql.conf tuning possibles
- All the kernel tuning values possibles
- fstab mount options
- limits.conf values
- I/O tests with boonie++ that shows that P400 is superior than IDE - as
expected
- 'massive' Google search combinations without answers
- Mandriva 2009.1: result is about 12 secs (but it need to be kernel 2.4
with PGSQL 7.2)
The real case:
~100k database insertions that runs in 2 min in the IDE, against ~40 minutes
(P400i) in the HP.
The same test in the HP Blade G5 P200 controller works fine.
Thanks for any answers/analisys.
Best regards.
--
Daniel Ferreira
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dfl.man@gmail.com
Subject: Re: IDE x SAS RAID 0 on HP DL 380 G5 P400i controller performance problem
In-Reply-To: <AANLkTimtyqefnmOF6xEihmoSjD333yGuYXRQ4PyVXe6j@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox