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 8AD5756719 for ; Mon, 14 Mar 2005 21:44:48 +0000 (GMT) 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 75613-01 for ; Mon, 14 Mar 2005 21:44:40 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.206]) by svr1.postgresql.org (Postfix) with ESMTP id C771A56755 for ; Mon, 14 Mar 2005 21:42:05 +0000 (GMT) Received: by wproxy.gmail.com with SMTP id 70so1855900wra for ; Mon, 14 Mar 2005 13:42:07 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=Jt2evZPzU0C2GcZkVXe5Aih58bG6yZHOdTMCmQb6G63kOUQa4fqZpnJZqzutUSjJGaB2jFnOhc/76Cr83IRGPcsZbnp1YToS4pp21Sha7oYx9yXNYNL/OYac0K8NkANlmPpy0N8DGMfXp3jLR3rMYmfwOAujZfUIwd+NJU/UaQ4= Received: by 10.54.22.38 with SMTP id 38mr305296wrv; Mon, 14 Mar 2005 13:42:07 -0800 (PST) Received: by 10.54.18.53 with HTTP; Mon, 14 Mar 2005 13:42:07 -0800 (PST) Message-ID: <33c6269f05031413424d749d5f@mail.gmail.com> Date: Mon, 14 Mar 2005 16:42:07 -0500 From: Alex Turner Reply-To: Alex Turner To: Merlin Moncure Subject: Re: Postgres on RAID5 Cc: pgsql-performance@postgresql.org, Arshavir Grigorian In-Reply-To: <6EE64EF3AB31D5448D0007DD34EEB3412A763F@Herge.rcsinc.local> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <6EE64EF3AB31D5448D0007DD34EEB3412A763F@Herge.rcsinc.local> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.229 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200503/287 X-Sequence-Number: 10992 He doesn't have a RAID controller, it's software RAID... Alex Turner netEconomis On Mon, 14 Mar 2005 16:18:00 -0500, Merlin Moncure wrote: > Alex Turner wrote: > > 35 Trans/sec is pretty slow, particularly if they are only one row at > > a time. I typicaly get 200-400/sec on our DB server on a bad day. Up > > to 1100 on a fresh database. > > Well, don't rule out that his raid controller is not caching his writes. > His WAL sync method may be overriding his raid cache policy and flushing > his writes to disk, always. Win32 has the same problem, and before > Magnus's O_DIRECT patch, there was no way to easily work around it > without turning fsync off. I'd suggest playing with different WAL sync > methods before trying anything else. > > Merli >