Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id D2A49632241 for ; Mon, 19 Jul 2010 09:24:13 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 23631-10 for ; Mon, 19 Jul 2010 12:24:04 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-iw0-f174.google.com (mail-iw0-f174.google.com [209.85.214.174]) by mail.postgresql.org (Postfix) with ESMTP id 7C2E9631AB8 for ; Mon, 19 Jul 2010 09:24:05 -0300 (ADT) Received: by iwn7 with SMTP id 7so4512373iwn.19 for ; Mon, 19 Jul 2010 05:24:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:date:message-id :subject:from:to:content-type; bh=iXwLmhOyNnLkYujH9k4TOVUkhMdHAWe3qvYimxly4GY=; b=cVv9/x8Gqa9NuvW+UQ4qU8eFAY2PjxY8XuYwovCz400fT5+Gon7pg1Ggb31bVNqiv4 Gx7bO1M5TI6RPlwBBsUzcxIM8yksEn+e6WijYt3zJndlGD6bpTVX/TUgO5IC8kEGio+o Sc2D6aR1f5R0i9OeWgfwnwz9S81OCDxgS5PTA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=Yl6QEZ73mqlRotlCA3gKGzCgP48w8JeXKhY5hZFFRoityx9A1B5DnZgYge/8t9tJ+E yFds8yhC1R/hmntczocM4XhNlgCwBP8vEbaD86KSknDKO3o7yqX+WSG1juk8Av+Esy0p 6BBdpPHgb9JRX7FbTmECfPV16klltqOPnf4do= MIME-Version: 1.0 Received: by 10.231.39.137 with SMTP id g9mr5681710ibe.133.1279542242114; Mon, 19 Jul 2010 05:24:02 -0700 (PDT) Received: by 10.231.173.131 with HTTP; Mon, 19 Jul 2010 05:24:01 -0700 (PDT) Date: Mon, 19 Jul 2010 09:24:01 -0300 Message-ID: Subject: IDE x SAS RAID 0 on HP DL 380 G5 P400i controller performance problem From: Daniel Ferreira de Lima To: pgsql-performance@postgresql.org Content-Type: multipart/alternative; boundary=000325575ffad0feca048bbca4a6 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.801 tagged_above=-10 required=5 tests=BAYES_50=0.8, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201007/280 X-Sequence-Number: 39669 --000325575ffad0feca048bbca4a6 Content-Type: text/plain; charset=ISO-8859-1 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 --000325575ffad0feca048bbca4a6 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi people,

I have a particular performance problem under a system i= nstalled.

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 500G= B 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 w= ith 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 ke= rnel tuning values possibles
- fstab mount options
- limits.conf valu= es
- I/O tests with boonie++ that shows that P400 is superior than IDE -= as expected
- 'massive' Google search combinations without answers
- Mandriv= a 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.

Th= anks for any answers/analisys.

Best regards.

-= -
Daniel Ferreira

--000325575ffad0feca048bbca4a6--