Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 0797F9FA4B6 for ; Wed, 17 Jan 2007 03:52:50 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 10758-05 for ; Wed, 17 Jan 2007 03:52:24 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.186]) by postgresql.org (Postfix) with ESMTP id 5ABB39FA589 for ; Wed, 17 Jan 2007 03:52:26 -0400 (AST) Received: by nf-out-0910.google.com with SMTP id x4so120316nfb for ; Tue, 16 Jan 2007 23:52:24 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=cQlHLJWQdjLihU4Doqwf8YK7BMb3j6Udo2V53ruCF8pa5YLQXiSkNwi+cYzjZWW5gkvK87N6taVEw+mCVwODFNUoUZKM4vA14YWWOVYk8UZ7VrwpFvuSo+eAByB4XQU371SOvhE/VaMRsmd8gBk0IZCh9qxY/sK2bS9X34+vkOU= Received: by 10.49.12.4 with SMTP id p4mr429493nfi.1169020341342; Tue, 16 Jan 2007 23:52:21 -0800 (PST) Received: by 10.49.37.2 with HTTP; Tue, 16 Jan 2007 23:52:21 -0800 (PST) Message-ID: Date: Wed, 17 Jan 2007 08:52:21 +0100 From: Federico To: "Bruno Wolff III" , Federico , pgsql-admin@postgresql.org Subject: Re: PostgreSQL data dir on linux raid software In-Reply-To: <20070116195017.GA10658@wolff.to> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <20070116195017.GA10658@wolff.to> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/130 X-Sequence-Number: 24286 On 1/16/07, Bruno Wolff III wrote: > On Mon, Jan 15, 2007 at 18:24:19 +0100, > Federico wrote: > > Hi, > > after some test i got that my performance problem described in the > > message http://archives.postgresql.org/pgsql-admin/2007-01/msg00116.php > > is issued by the linux software raid 1 on my discs (yes the silicon > > image controller has only fake raid hardware). > > > > I found this old message that seems the same problem like mine. > > > > http://archives.postgresql.org/pgsql-admin/2003-12/msg00219.php > > > > Because the message is quite old I'm wondering if there're some hdparm > > settings to enable on the disks that compose the array to have better > > performances in fsync. > > > > For now I cannot mount an expensive scsi raid hardware so i need to > > have raid software. > > Are you using Linux's software raid (md devices) or dmraid using the controller > to do some of the work? If you aren't using the native linux software raid, > you might want to try it instead. You will need to rebuild the array to do > this, so this might not be an easy thing to do. The bios will also need to > support disabling the raid and exposing the individual disks (but that is > a fairly normal thing for bios's). If linux can see the individual disks, > then you should be able to use hdparm to tweak their settings. > Hi Bruno, thank you for the answer. Yesterday I resolved the issue. The problem cause was the APIC functionality on my motherboard that messed the flush on the disk. Disabling the apic in the bios I got a good performance increase. With ab i made a test with 1000 request on concurrency 400 and got 20 seconds of mean response time without instance tuning. :D Best Regards Federico Campoli