X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CE82832A077 for ; Sat, 2 Oct 2004 00:56:48 +0100 (BST) 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 96561-08 for ; Fri, 1 Oct 2004 23:56:37 +0000 (GMT) Received: from leda.steelsun.com (dsl093-240-204.ral1.dsl.speakeasy.net [66.93.240.204]) by svr1.postgresql.org (Postfix) with ESMTP id B96A0329C63 for ; Sat, 2 Oct 2004 00:56:38 +0100 (BST) Received: from leda.steelsun.com (localhost [127.0.0.1]) by leda.steelsun.com (8.12.11/8.12.8) with ESMTP id i91NuVT9009849; Fri, 1 Oct 2004 19:56:31 -0400 Received: from localhost (cfowler@localhost) by leda.steelsun.com (8.12.11/8.12.11/Submit) with ESMTP id i91NuVf1009846; Fri, 1 Oct 2004 19:56:31 -0400 X-Authentication-Warning: leda.steelsun.com: cfowler owned process doing -bs Date: Fri, 1 Oct 2004 19:56:31 -0400 (EDT) From: Christian Fowler X-X-Sender: cfowler@leda.steelsun.com To: Igor Maciel Macaubas Cc: pgsql-admin@postgresql.org Subject: Re: Does PostgreSQL Stores its database in multiple disks? In-Reply-To: <002e01c4a7f9$d1ec0de0$6801a8c0@providerst.local> Message-ID: References: <002e01c4a7f9$d1ec0de0$6801a8c0@providerst.local> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/41 X-Sequence-Number: 15035 Igor, I would recommend you investigate LVM: http://www.tldp.org/HOWTO/LVM-HOWTO/ This enables you to string multiple physical units into a single volume - as well as expand and grow the volume. I am unsure about postgres consequences of this for as much data as you have, so I will leave it up to others to comment about this. However, my recommendation is for a modest investment of a third 120GB drive and a RAID card, you could do RAID 5 with 3 disks and get 240GB of storage. On Fri, 1 Oct 2004, Igor Maciel Macaubas wrote: > Hi Guys, > > I have a PostgreSQL server, running 7.4.2, that will store a really > large amount of data (200GB) being migrated from an Oracle database. I > have a machine with two 120GB Ultra ATA IDE disks, and I'd like to know > if PostgreSQL could split it over both disks (that gives me 240GB or > storage). Does he do this automatically ? Or I'll have to split it > manually, creating symbolic links on my file system (ext3)? Does anyone > ever stored a database (see, it's ONE database only, not a cluster) on > multiple disks ? > > What about PgSQL 8? It'll include this feature? > > Thanks! > > Regards, > Igor > -- > igor@providerst.com.br > [ \ / [ >X< spider@steelsun.com | http://www.viovio.com/ [ / \