Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 7479D9FB216 for ; Mon, 15 Jan 2007 13:24:38 -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 90402-02 for ; Mon, 15 Jan 2007 13:24:22 -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.184]) by postgresql.org (Postfix) with ESMTP id F18639FA0C0 for ; Mon, 15 Jan 2007 13:24:22 -0400 (AST) Received: by nf-out-0910.google.com with SMTP id x4so2177530nfb for ; Mon, 15 Jan 2007 09:24:21 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=dNrny8s9aE9YvIPvQuF1axH6UMsWUQ/9QVR/ijZ1I0RX9lWoZgR8rWo0eqPqwm5fXIT3zQmjg8+svVykZoWqQ9RkCQsFxY2vKnYe7XP5n2usxb96ZNsW6kNfqf5rWbwhz3hLEN3mzG2s8vTKLmqpj9jkSPT8a8CpMNFUleVEra4= Received: by 10.49.65.19 with SMTP id s19mr4450841nfk.1168881859778; Mon, 15 Jan 2007 09:24:19 -0800 (PST) Received: by 10.49.37.2 with HTTP; Mon, 15 Jan 2007 09:24:19 -0800 (PST) Message-ID: Date: Mon, 15 Jan 2007 18:24:19 +0100 From: Federico To: pgsql-admin@postgresql.org Subject: PostgreSQL data dir on linux raid software MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/124 X-Sequence-Number: 24280 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. Thanks in advance Best Regards Federico Campoli