Received: from localhost (unknown [200.46.204.184])
	by developer.postgresql.org (Postfix) with ESMTP id 4BE9A2E0052
	for <pgsql-performance-postgresql.org@developer.postgresql.org>;
	Tue, 22 Apr 2008 12:25:48 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 66809-08
	for <pgsql-performance-postgresql.org@developer.postgresql.org>;
	Tue, 22 Apr 2008 12:25:44 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from rn-out-0910.google.com (rn-out-0910.google.com
 [64.233.170.187])
	by developer.postgresql.org (Postfix) with ESMTP id CC7672E004C
	for <pgsql-performance@postgresql.org>;
	Tue, 22 Apr 2008 12:25:44 -0300 (ADT)
Received: by rn-out-0910.google.com with SMTP id i24so856471rng.0
	for <pgsql-performance@postgresql.org>;
	Tue, 22 Apr 2008 08:25:44 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	bh=9NVdBB5rZyTCa6XvebcCoWYKv3gS8kng/qCkNF8pvyE=;
	b=B8o/fvufesDsDCDXA8XsSgUAsxw/nDbAfjUc2Alk/yXGw/7QmaKPtjDd7gsM0BXj+zJpQYleEHWHvQ3bdfewG+t8ErUXbBv5GuJOBJnKsLfAEpCXYDfCDbQDiFARr8i3TEQeu7GFxehOrRuDXiOg9HjuX30g19B7sJXTXlWNCXY=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=ne0bajrvbBAhRcWFcxw2H6rICZcNPvXbBpDfliCuC3e/b9u4X3oMFMo4RPDYRVPzTtXNw6o4evzcw1v4YPhMxKK6dFayvNMiAgUk9GDAjLZGlktf/qfazvj/4XpMYPIwY36EwUqRKNF2jaCtR9Zo65r6dTR12nCG4erhKC/ZfTU=
Received: by 10.114.183.1 with SMTP id g1mr437336waf.3.1208877943201;
	Tue, 22 Apr 2008 08:25:43 -0700 (PDT)
Received: by 10.114.137.7 with HTTP; Tue, 22 Apr 2008 08:25:42 -0700 (PDT)
Message-ID: <dcc563d10804220825j592cb3fdtf0d977dcf4e51312@mail.gmail.com>
Date: Tue, 22 Apr 2008 09:25:42 -0600
From: "Scott Marlowe" <scott.marlowe@gmail.com>
To: "Thomas Spreng" <spreng@socket.ch>
Subject: Re: Oddly slow queries
Cc: "Christopher Browne" <cbbrowne@acm.org>, pgsql-performance@postgresql.org
In-Reply-To: <7A2BA520-ED19-418F-9339-95C7F7158664@socket.ch>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <3D7728ED-3D36-47E6-9266-351073ED4E11@socket.ch>
	<op.t9odybcgcigqcu@apollo13.peufeu.com>
	<AE4F81FF-C8BE-44BC-A79D-48EC5BF20162@socket.ch>
	<60y77du7qs.fsf@dba2.int.libertyrms.com>
	<20B852C4-2ACA-445F-9289-558B6C86BAB4@socket.ch>
	<87mynp3h3q.fsf@wolfe.cbbrowne.com>
	<7A2BA520-ED19-418F-9339-95C7F7158664@socket.ch>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200804/317
X-Sequence-Number: 29810

On Tue, Apr 22, 2008 at 7:42 AM, Thomas Spreng <spreng@socket.ch> wrote:
>
>  I think I'll upgrade PostgreSQL to the latest 8.3 version in the next
>  few days anyway, along with a memory upgrade (from 1.5GB to 4GB) and a
>  new 2x RAID-1 (instead of RAID-5) disk configuration. I hope that this
>  has already a noticeable impact on the performance.

Note that if you have a good RAID controller with battery backed cache
and write back enabled, then you're probably better or / at least as
well off using four disks in a RAID-10 than two separate RAID-1 sets
(one for xlog and one for data).

Test to see.  I've had better performance in general with the RAID-10 setup.