X-Original-To: pgsql-performance-postgresql.org@postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 8858E9FA5C3
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 14 Jun 2006 04:52:32 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 17619-08 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 14 Jun 2006 04:52:28 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from nz-out-0102.google.com (nz-out-0102.google.com
 [64.233.162.193])
	by postgresql.org (Postfix) with ESMTP id EBC769FA3C0
	for <pgsql-performance@postgresql.org>;
	Wed, 14 Jun 2006 04:52:27 -0300 (ADT)
Received: by nz-out-0102.google.com with SMTP id s1so76988nze
	for <pgsql-performance@postgresql.org>;
	Wed, 14 Jun 2006 00:52:26 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:mime-version:content-type;
	b=owtC/LNZJLDMDMKl6e/BBLchHyHmlhwHrxWRVjDdWeoKlLUfclEnUJBnUQrRJDEgbr9tOTK+DzfvwaJ1dAOut+d1RCNlWLxAUr23jc2WF+h5w8AbPhP7wSp556m1qEf5tUpk3EY0RlMcIqb3YIlH6Ga0WnJjMGcF4vPAkk7HnAY=
Received: by 10.64.156.3 with SMTP id d3mr247053qbe;
	Wed, 14 Jun 2006 00:52:26 -0700 (PDT)
Received: by 10.65.75.17 with HTTP; Wed, 14 Jun 2006 00:52:26 -0700 (PDT)
Message-ID: <9e4684ce0606140052m62552d41xa9364b9d4e266c97@mail.gmail.com>
Date: Wed, 14 Jun 2006 09:52:26 +0200
From: "hubert depesz lubaczewski" <depesz@gmail.com>
To: Pgsql-Performance <pgsql-performance@postgresql.org>
Subject: how to partition disks
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_26035_5515386.1150271546893"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200606/240
X-Sequence-Number: 19597

------=_Part_26035_5515386.1150271546893
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

hi
i'm waiting for new server to arrive.
for the server i will get hp msa1000, with 14 discs (72g, 15000 rpm).
what kind of partitioning you suggest, to get maximum performance?
for system things i will have separate discs, so whole array is only for
postgresql.

data processing is oltp, but with large amounts of write operations.

any hints?

should i go with 3 partitions, or just 1? or 2?

depesz

-- 
http://www.depesz.com/ - nowy, lepszy depesz

------=_Part_26035_5515386.1150271546893
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

hi<br>i'm waiting for new server to arrive.<br>for the server i will get hp msa1000, with 14 discs (72g, 15000 rpm).<br>what kind of partitioning you suggest, to get maximum performance?<br>for system things i will have separate discs, so whole array is only for postgresql.
<br><br>data processing is oltp, but with large amounts of write operations.<br><br>any hints?<br><br>should i go with 3 partitions, or just 1? or 2?<br><br>depesz<br clear="all"><br>-- <br><a href="http://www.depesz.com/">
http://www.depesz.com/</a> - nowy, lepszy depesz

------=_Part_26035_5515386.1150271546893--