X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 855B75E3639 for ; Wed, 18 Aug 2004 05:18:26 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 60633-06 for ; Wed, 18 Aug 2004 08:18:20 +0000 (GMT) Received: from ludojad.itpp.pl (ludojad.itpp.pl [193.41.112.10]) by svr1.postgresql.org (Postfix) with ESMTP id 7D5B75E3633 for ; Wed, 18 Aug 2004 05:18:19 -0300 (ADT) Received: from [193.41.112.10] (ludojad.itpp.pl [193.41.112.10]) by ludojad.itpp.pl (Postfix) with ESMTP id A21FF1035FD for ; Wed, 18 Aug 2004 10:18:19 +0200 (CEST) Message-ID: <412310CB.8080908@ludojad.itpp.pl> Date: Wed, 18 Aug 2004 10:18:19 +0200 From: eleven User-Agent: Mozilla Thunderbird 0.7.1 (X11/20040803) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: high load caused by I/O - a hint Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/267 X-Sequence-Number: 7903 Hello, This is not strictly PostgreSQL performance hint, but may be helpful to someone with problems like mine. As I earlier posted, I was experiencing very high load average on one of my Linux database servers (IBM eServer 345, SCSI disks on LSI Logic controller) caused by I/O bottleneck. INSERTs were really slow, even after many days of tweaking PostgreSQL configuration. The problem appeared to be in the Linux kernel itself - using acpi=ht and noapic boot parameters solved my performance problems. Load average dropped below 1.0 (before, it was as high as ten in peak) and the database works much, much faster. -- 11.