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 0755C5E3633 for ; Wed, 18 Aug 2004 05:55:50 -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 74762-05 for ; Wed, 18 Aug 2004 08:55:44 +0000 (GMT) Received: from mail.najdi.si (elfstone.noviforum.si [193.189.169.107]) by svr1.postgresql.org (Postfix) with ESMTP id BE0CC5E46DE for ; Wed, 18 Aug 2004 05:55:42 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by elfstone.noviforum.si (ESMTP) with ESMTP id 52FDA1B913; Wed, 18 Aug 2004 10:49:06 +0200 (CEST) Received: from elbereth.noviforum.si (elbereth.noviforum.si [192.168.2.26]) by elfstone.noviforum.si (ESMTP) with ESMTP id 22B951B912; Wed, 18 Aug 2004 10:49:06 +0200 (CEST) Received: from elbereth.noviforum.si (localhost [127.0.0.1]) by elbereth.noviforum.si (8.12.10/8.12.10) with ESMTP id i7I8psJ7027558; Wed, 18 Aug 2004 10:51:54 +0200 Received: (from gregab@localhost) by elbereth.noviforum.si (8.12.10/8.12.10/Submit) id i7I8psZA027557; Wed, 18 Aug 2004 10:51:54 +0200 Date: Wed, 18 Aug 2004 10:51:54 +0200 From: Grega Bremec To: eleven Cc: pgsql-performance@postgresql.org Subject: Re: high load caused by I/O - a hint Message-ID: <20040818085154.GA27512@elbereth.noviforum.si> References: <412310CB.8080908@ludojad.itpp.pl> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="17pEHd4RhPHOinZp" Content-Disposition: inline In-Reply-To: <412310CB.8080908@ludojad.itpp.pl> User-Agent: Mutt/1.4.2i Organization: Noviforum, Ltd., Software & Media X-Virus-Scanned: by Najdi.si 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/268 X-Sequence-Number: 7904 --17pEHd4RhPHOinZp Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable ...and on Wed, Aug 18, 2004 at 10:18:19AM +0200, eleven used the keyboard: > Hello, >=20 > This is not strictly PostgreSQL performance hint, but may be > helpful to someone with problems like mine. >=20 > 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= =20 > Logic controller) caused by I/O bottleneck. >=20 > INSERTs were really slow, even after many days of > tweaking PostgreSQL configuration. The problem appeared to be > in the Linux kernel itself - using acpi=3Dht 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. Hello, Did you try with acpi=3Dnoidle? This proved to be of help on many an occasion before, and you don't have to give up any functionality over it. It's just that the ACPI BIOS is broken and overloads the system with idle calls. Other than that, general guidelines would be, don't combine APM and ACPI, and rather use proper SMP code for hyperthreaded machines than just the ACPI CPU enumeration feature. There's also a new option with 2.6.8.1, called CONFIG_SCHED_SMT that is supposed to handle some cases SMP code had problems with better, at the cost of slight overhead in other areas. My advice would be, if you have an option to choose between APM and ACPI, go for ACPI. It's the future, it's being developed actively, it does a whole lot more than APM (that was really only about power management), and last but not least, I've been using it for four years on over fifty SMP machines and I never ever had a problem beyond the scope of what noidle could fix (knocks-on-wood). :) HTH, --=20 Grega Bremec Senior Administrator Noviforum Ltd., Software & Media http://www.noviforum.si/ --17pEHd4RhPHOinZp Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQFBIxiqDo/EMYD4+osRAiPpAKCfQ4zAk41JIKNKTBKpDXuAROAUJgCfdphe hKoDVm4gImW9qNn6rO+ogyU= =+j70 -----END PGP SIGNATURE----- --17pEHd4RhPHOinZp--