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 B544332A14C for ; Sat, 2 Oct 2004 01:20:34 +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 02149-08 for ; Sat, 2 Oct 2004 00:20:26 +0000 (GMT) Received: from relay.snowman.net (relay.snowman.net [66.92.160.56]) by svr1.postgresql.org (Postfix) with ESMTP id 30A3B32A11D for ; Sat, 2 Oct 2004 01:20:28 +0100 (BST) Received: from ns.snowman.net (ns.snowman.net [10.10.0.2]) by relay.snowman.net (8.12.11/8.12.11/Debian-5) with ESMTP id i920KJDO005320; Fri, 1 Oct 2004 20:20:19 -0400 Received: from ns.snowman.net (localhost [127.0.0.1]) by ns.snowman.net (8.12.11/8.12.11/Debian-5) with ESMTP id i920KsRD013502; Fri, 1 Oct 2004 20:20:54 -0400 Received: (from sfrost@localhost) by ns.snowman.net (8.12.11/8.12.11/Debian-5) id i920KsQ4013500; Fri, 1 Oct 2004 20:20:54 -0400 Date: Fri, 1 Oct 2004 20:20:53 -0400 From: Stephen Frost To: Igor Maciel Macaubas Cc: pgsql-admin@postgresql.org Subject: Re: Does PostgreSQL Stores its database in multiple disks? Message-ID: <20041002002053.GM21419@ns.snowman.net> Mail-Followup-To: Igor Maciel Macaubas , pgsql-admin@postgresql.org References: <002e01c4a7f9$d1ec0de0$6801a8c0@providerst.local> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="wwGdcB8pEpD07BWh" Content-Disposition: inline In-Reply-To: <002e01c4a7f9$d1ec0de0$6801a8c0@providerst.local> X-Editor: Vim http://www.vim.org/ X-Info: http://www.snowman.net X-Operating-System: Linux/2.4.24ns.3.0 (i686) X-Uptime: 20:20:07 up 244 days, 19:20, 12 users, load average: 0.04, 0.11, 0.08 User-Agent: Mutt/1.5.5.1+cvs20040105i 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/42 X-Sequence-Number: 15036 --wwGdcB8pEpD07BWh Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable * Igor Maciel Macaubas (igor@providerst.com.br) wrote: > 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 ma= chine with two 120GB Ultra ATA IDE disks, and I'd like to know if PostgreSQ= L 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 sys= tem (ext3)? > Does anyone ever stored a database (see, it's ONE database only, not a cl= uster) on multiple disks ? >=20 > What about PgSQL 8? It'll include this feature? An alternative might be to use some kind of LVM (such as device mapper/LVM2 under Linux) to combine the two disks into one logical device. Stephen --wwGdcB8pEpD07BWh Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFBXfRlrzgMPqB3kigRAk2fAJ0WCzJXNu4KhlvLIAn2E9QmHusXfgCeNdxC JVtMsiSNpAITtb/S3q9EUds= =nxPi -----END PGP SIGNATURE----- --wwGdcB8pEpD07BWh--