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 14FEF9FA5C3 for ; Wed, 14 Jun 2006 05:26:52 -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 19081-10 for ; Wed, 14 Jun 2006 05:26:47 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.aeccom.com (port-83-236-156-26.static.qsc.de [83.236.156.26]) by postgresql.org (Postfix) with ESMTP id 914809FA3C0 for ; Wed, 14 Jun 2006 05:26:47 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by mail.aeccom.com (Postfix) with ESMTP id 06B3C1D131; Wed, 14 Jun 2006 10:26:46 +0200 (CEST) Received: from mail.aeccom.com ([127.0.0.1]) by localhost (gate6.aeccom.com [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 18927-01-2; Wed, 14 Jun 2006 10:26:45 +0200 (CEST) Received: from [192.168.2.14] (andes.core.aeccom.com [192.168.2.14]) by mail.aeccom.com (Postfix) with ESMTP id 212FF1D0AF; Wed, 14 Jun 2006 10:26:45 +0200 (CEST) Message-ID: <448FC843.1090205@aeccom.com> Date: Wed, 14 Jun 2006 10:26:43 +0200 From: Sven Geisler Organization: AEC/communications GmbH User-Agent: Thunderbird 1.5.0.4 (Windows/20060516) MIME-Version: 1.0 To: hubert depesz lubaczewski CC: Pgsql-Performance Subject: Re: how to partition disks References: <9e4684ce0606140052m62552d41xa9364b9d4e266c97@mail.gmail.com> In-Reply-To: <9e4684ce0606140052m62552d41xa9364b9d4e266c97@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: amavisd-new at aeccom.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/241 X-Sequence-Number: 19598 Hi Hubert, hubert depesz lubaczewski schrieb: > 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? > You should configure your discs to RAID 10 volumes. You should set up a separate volume for WAL. A volume for an additional table space may also useful. In your case I would do 2 partitions: 1. RAID 10 with 8 discs for general data 2. RAID 10 with 4 discs for WAL (two disk as spare) You may split the first volume in two volumes for a second table space if you Server doesn't have enough RAM and you have a high disk read I/O. Cheers Sven.