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 99E7156570 for ; Mon, 28 Feb 2005 08:10:44 +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 02755-08 for ; Mon, 28 Feb 2005 08:10:40 +0000 (GMT) Received: from mail.logi-track.com (burro.logi-track.com [213.239.193.212]) by svr1.postgresql.org (Postfix) with ESMTP id A60CD5656B for ; Mon, 28 Feb 2005 08:10:39 +0000 (GMT) Received: from kingfisher.intern.logi-track.com (pD95DD1F9.dip0.t-ipconnect.de [217.93.209.249]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.logi-track.com (Postfix) with ESMTP id A1882307F7; Mon, 28 Feb 2005 09:10:41 +0100 (CET) Received: from [127.0.0.1] (localhost [127.0.0.1]) by kingfisher.intern.logi-track.com (Postfix) with ESMTP id F04C1AB2A4; Mon, 28 Feb 2005 09:10:36 +0100 (CET) Message-ID: <4222D1FC.1020007@logi-track.com> Date: Mon, 28 Feb 2005 09:10:36 +0100 From: Markus Schaber User-Agent: Mozilla Thunderbird 1.0 (X11/20050116) X-Accept-Language: de-DE, de, en-us, en MIME-Version: 1.0 To: John Allgood Cc: pgsql-performance@postgresql.org, john@arbash-meinel.com Subject: Re: Peformance Tuning Opterons/ Hard Disk Layout References: <421E1D8A.8050203@turbocorp.com> In-Reply-To: <421E1D8A.8050203@turbocorp.com> X-Enigmail-Version: 0.90.1.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200502/370 X-Sequence-Number: 10699 Hi, John, John Allgood schrieb: > My question is what is the best way to setup > postgres databases on different disks. I have setup multiple postmasters > on this system as a test. The only problem was configuring each > databases "ie postgresql.conf, pg_hba.conf". Is there anyway in > postgres to have everything in one cluster and have it seperated onto > multiple drives. Using PostgreSQL 8.0, the newly introduced "tablespaces" solve all this: http://www.postgresql.org/docs/8.0/interactive/manage-ag-tablespaces.html Using PostgreSQL 7.4, you can relatively easy create single databases on different drives. However, separating out single tables or indices involves some black symlink magic. See google and http://www.postgresql.org/docs/7.4/interactive/manage-ag-alternate-locs.html HTH, Markus -- markus schaber | dipl. informatiker logi-track ag | rennweg 14-16 | ch 8001 zürich phone +41-43-888 62 52 | fax +41-43-888 62 53 mailto:schabios@logi-track.com | www.logi-track.com