From igor@providerst.com.br Fri Oct 1 20:56:17 2004 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 956CF32A151 for ; Fri, 1 Oct 2004 21:56:17 +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 56928-02 for ; Fri, 1 Oct 2004 20:56:14 +0000 (GMT) Received: from providerst.com.br (unknown [200.253.138.61]) by svr1.postgresql.org (Postfix) with ESMTP id 535C132A14E for ; Fri, 1 Oct 2004 21:56:13 +0100 (BST) Brma: igor [192.168.1.104] (may be forged) Received: from sistemas (igor [192.168.1.104] (may be forged)) by providerst.com.br (8.11.6/8.11.6) with SMTP id i91KnW614316 for ; Fri, 1 Oct 2004 17:49:32 -0300 Message-ID: <002e01c4a7f9$d1ec0de0$6801a8c0@providerst.local> From: "Igor Maciel Macaubas" To: Subject: Does PostgreSQL Stores its database in multiple disks? Date: Fri, 1 Oct 2004 18:01:23 -0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_002B_01C4A7E0.A990D290" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.6 tagged_above=0.0 required=5.0 tests=HTML_40_50, HTML_FONTCOLOR_BLUE, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200410/31 X-Sequence-Number: 15025 This is a multi-part message in MIME format. ------=_NextPart_000_002B_01C4A7E0.A990D290 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi Guys, I have a PostgreSQL server, running 7.4.2, that will store a really large a= mount of data (200GB) being migrated from an Oracle database. I have a mach= ine 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 syste= m (ext3)? Does anyone ever stored a database (see, it's ONE database only, not a clus= ter) on multiple disks ? What about PgSQL 8? It'll include this feature? Thanks! Regards, Igor -- igor@providerst.com.br ------=_NextPart_000_002B_01C4A7E0.A990D290 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi Guys,
 
I have a PostgreSQL server, running 7.4= .2, that=20 will store a really large amount of data (200GB) being migrated from an Oracle database. I have a machine with two = 120GB=20 Ultra ATA IDE disks, and I'd like to know if PostgreSQL could split it over= both=20 disks (that gives me 240GB or storage). Does he do this automatically=20 ?
Or I'll have to split it manually, crea= ting=20 symbolic links on my file system (ext3)?
Does anyone ever stored a database (see= , it's=20 ONE database only, not a cluster) on multiple disks ?
 
What about PgSQL 8? It'll include this= =20 feature?
 
Thanks!
 
Regards,
Igor
--
igor@providerst.com.br
 
------=_NextPart_000_002B_01C4A7E0.A990D290-- From bnl@tiscali.se Fri Oct 1 21:09:42 2004 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 71F7832A1A3 for ; Fri, 1 Oct 2004 22:09:42 +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 59488-04 for ; Fri, 1 Oct 2004 21:09:31 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id A9DBF32A192 for ; Fri, 1 Oct 2004 22:09:32 +0100 (BST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i91L9T5a060969 for ; Fri, 1 Oct 2004 21:09:29 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i91L9SUN060961 for pgsql-admin@postgresql.org; Fri, 1 Oct 2004 21:09:28 GMT From: =?ISO-8859-1?Q?Bj=F6rn?= Lundin X-Newsgroups: comp.databases.postgresql.admin Subject: Re: Does PostgreSQL Stores its database in multiple disks? Date: Fri, 01 Oct 2004 23:09:13 +0200 Organization: Hub.Org Networking Services Lines: 18 Message-ID: References: <002e01c4a7f9$d1ec0de0$6801a8c0@providerst.local> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8Bit X-Complaints-To: usenet@news.hub.org User-Agent: KNode/0.8.0 To: pgsql-admin@postgresql.org 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/53 X-Sequence-Number: 15046 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). Have you considered Raid? Raid 0 or 1 (I keep forgetting which) will make the 2 disks to appear as one (The other will mirror one disk) -- /Björn ------------------------------------------------------------------- http://lundin.homelinux.net Registered Linux User No. 267342 From hjohnson@nypost.com Fri Oct 1 21:18:19 2004 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 42B9232A1FD for ; Fri, 1 Oct 2004 22:18:19 +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 62567-06 for ; Fri, 1 Oct 2004 21:18:15 +0000 (GMT) Received: from gwen.enluminaire.com (h-67-100-183-100.nycmny83.covad.net [67.100.183.100]) by svr1.postgresql.org (Postfix) with ESMTP id C872832A1D6 for ; Fri, 1 Oct 2004 22:18:16 +0100 (BST) Received: from [192.168.1.200] (unknown [192.168.1.200]) by gwen.enluminaire.com (Postfix) with ESMTP id 98658183E3D; Fri, 1 Oct 2004 17:18:11 -0400 (EDT) Message-ID: <415DC978.9030209@nypost.com> Date: Fri, 01 Oct 2004 17:17:44 -0400 From: Heather Johnson User-Agent: Mozilla Thunderbird 0.8 (X11/20040918) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Igor Maciel Macaubas Cc: pgsql-admin@postgresql.org Subject: Re: Does PostgreSQL Stores its database in multiple disks? References: <002e01c4a7f9$d1ec0de0$6801a8c0@providerst.local> In-Reply-To: <002e01c4a7f9$d1ec0de0$6801a8c0@providerst.local> X-Enigmail-Version: 0.86.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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/32 X-Sequence-Number: 15026 Could you configure the two volumes as one volume with RAID? If so, then Postgres shouldn't require any special adjusting to accomplish what you are after. Heather Johnson Senior Database Programmer New York Post 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 > From igor@providerst.com.br Fri Oct 1 21:23:54 2004 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 2EA4632A1AC for ; Fri, 1 Oct 2004 22:23:54 +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 64367-03 for ; Fri, 1 Oct 2004 21:23:50 +0000 (GMT) Received: from providerst.com.br (unknown [200.253.138.61]) by svr1.postgresql.org (Postfix) with ESMTP id BDBD532A1CD for ; Fri, 1 Oct 2004 22:23:50 +0100 (BST) Brma: igor [192.168.1.104] (may be forged) Received: from sistemas (igor [192.168.1.104] (may be forged)) by providerst.com.br (8.11.6/8.11.6) with SMTP id i91LH7607410; Fri, 1 Oct 2004 18:17:07 -0300 Message-ID: <000e01c4a7fd$ac39a540$6801a8c0@providerst.local> From: "Igor Maciel Macaubas" To: "Heather Johnson" Cc: References: <002e01c4a7f9$d1ec0de0$6801a8c0@providerst.local> <415DC978.9030209@nypost.com> Subject: Re: Does PostgreSQL Stores its database in multiple disks? Date: Fri, 1 Oct 2004 18:28:57 -0300 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 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/34 X-Sequence-Number: 15028 Hi, Heather, I might be able to do it. Let me check .. I can buy a cheap RAID IDE controller and try to mount everything as one. I was looking at the change log of postgresql 8, and figured out that it supports tablespace now, giving me the flexibility of storing my tables in different disks and even different directories if I want. So, I'm thinking in, instead of migrating it from oracle to 7.4.2, migrate it directly to 8.0 and be a beta tester for 8.0. that would be a great experiment, don't you think? Is anyone here using pgsql 8.0 in production now? I'm already using it in my development environment, around 80 tables but just a few megabytes of data (it's development). Is anyone here using it in a real world application by now? Regards, Igor -- igor@providerst.com.br ----- Original Message ----- From: "Heather Johnson" To: "Igor Maciel Macaubas" Cc: Sent: Friday, October 01, 2004 6:17 PM Subject: Re: [ADMIN] Does PostgreSQL Stores its database in multiple disks? > Could you configure the two volumes as one volume with RAID? If so, then > Postgres shouldn't require any special adjusting to accomplish what you > are after. > > Heather Johnson > Senior Database Programmer > New York Post > > 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 >> From cbbrowne@acm.org Fri Oct 1 23:09:43 2004 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 58D9832A26C for ; Sat, 2 Oct 2004 00:09:43 +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 85083-10 for ; Fri, 1 Oct 2004 23:09:31 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 7947D32A20D for ; Sat, 2 Oct 2004 00:09:33 +0100 (BST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i91N9U5a089207 for ; Fri, 1 Oct 2004 23:09:30 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i91Mo1IT085090 for pgsql-admin@postgresql.org; Fri, 1 Oct 2004 22:50:01 GMT From: Christopher Browne X-Newsgroups: comp.databases.postgresql.admin Subject: Re: Does PostgreSQL Stores its database in multiple disks? Date: Fri, 01 Oct 2004 18:10:12 -0400 Organization: cbbrowne Computing Inc Lines: 38 Message-ID: References: <002e01c4a7f9$d1ec0de0$6801a8c0@providerst.local> <415DC978.9030209@nypost.com> <000e01c4a7fd$ac39a540$6801a8c0@providerst.local> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1006 (Gnus v5.10.6) XEmacs/21.4 (Security Through Obscurity, linux) Cancel-Lock: sha1:CaCZVnEsvJ31zxTPa31/14CqsWs= To: pgsql-admin@postgresql.org 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/39 X-Sequence-Number: 15033 Centuries ago, Nostradamus foresaw when igor@providerst.com.br ("Igor Maciel Macaubas") would write: > Heather, I might be able to do it. Let me check .. I can buy a cheap > RAID IDE controller and try to mount everything as one. You'd be about as well off, if you're running Linux, to use the "md" RAID driver that simulates RAID in software. > I was looking at the change log of postgresql 8, and figured out that > it supports tablespace now, giving me the flexibility of storing my > tables in different disks and even different directories if I want. > > So, I'm thinking in, instead of migrating it from oracle to 7.4.2, > migrate it directly to 8.0 and be a beta tester for 8.0. that would be > a great experiment, don't you think? > Is anyone here using pgsql 8.0 in production now? I'm already using it > in my development environment, around 80 tables but just a few > megabytes of data (it's development). Is anyone here using it in a > real world application by now? Nobody should be considering using 8.0 for anything called "production use" at this point in time, because it is NOT guaranteed that there will be an upgrade path to the "official" release. Now, I'm possibly 'somewhat conservative,' as someone that wouldn't want to call a system 'production' if it's using cheapo IDE drives. But what you're proposing isn't merely a matter of 'trying to jump the learning curve;' you're tempting, instead, the "learning cliff," and the results of problems, there, are that instead of scuffing your knees, you wind up falling 8 stories and going "splat." -- output = ("cbbrowne" "@" "ntlug.org") http://www.ntlug.org/~cbbrowne/spiritual.html Rules of the Evil Overlord #33. "I won't require high-ranking female members of my organization to wear a stainless-steel bustier. Morale is better with a more casual dress-code. Similarly, outfits made entirely from black leather will be reserved for formal occasions." From spider@steelsun.com Fri Oct 1 23:56:48 2004 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/ [ / \ From sfrost@snowman.net Sat Oct 2 00:20:34 2004 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-- From smarlowe@qwest.net Sat Oct 2 00:38:23 2004 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 EA18F32A1BA for ; Sat, 2 Oct 2004 01:38:23 +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 06024-04 for ; Sat, 2 Oct 2004 00:38:11 +0000 (GMT) Received: from mpls-qmqp-04.inet.qwest.net (mpls-qmqp-04.inet.qwest.net [63.231.195.115]) by svr1.postgresql.org (Postfix) with SMTP id B22B932A1A2 for ; Sat, 2 Oct 2004 01:38:13 +0100 (BST) Received: (qmail 37700 invoked by uid 0); 2 Oct 2004 00:38:14 -0000 Received: from mpls-pop-03.inet.qwest.net (63.231.195.3) by mpls-qmqp-04.inet.qwest.net with QMQP; 2 Oct 2004 00:38:14 -0000 Received: from 63-227-127-37.dnvr.qwest.net (HELO ?10.0.0.2?) (63.227.127.37) by mpls-pop-03.inet.qwest.net with SMTP; 2 Oct 2004 00:38:04 -0000 Date: Fri, 01 Oct 2004 18:40:02 -0600 Message-Id: <1096677602.2611.17.camel@localhost.localdomain> From: "Scott Marlowe" 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> References: <002e01c4a7f9$d1ec0de0$6801a8c0@providerst.local> Content-Type: text/plain Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Content-Transfer-Encoding: 7bit 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/43 X-Sequence-Number: 15037 On Fri, 2004-10-01 at 15:01, 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, I'd normally advise against ATA drives in a production system. If you must use them, make sure the write cache is turned off or you risk data corruption should the machine lose power. > 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 ? Not automatically, no. With 8.0's table space feature, you could put half your database tables etc... on one drive and one half on another. This would require you to keep track of how much your putting in one or other, and could get rather tedious. If you don't mind shutting down the database and copying / linking the individual table files you could do that, but again, that's gonna require you to do a lot of housekeeping on your own. Lastly, you could use some kind of RAID or LVM setup to accomplish this. For testing purposes running this on a RAID-0 with linux's MD or LVM modules should work fine. But RAID-0 has no redundancy and a single drive failure means the whole set goes down. With 4 drives you could set up a RAID 1+0 array (or 0+1) and place your data there. That setup could survive a single drive failure and keep on going. If your database will be writing a lot, it would be well worth your while to investigate a SCSI RAID controller with battery backed cache set to write back. > Or I'll have to split it manually, creating symbolic links on my file > system (ext3)? That would be a lot of work. > Does anyone ever stored a database (see, it's ONE database only, not a > cluster) on multiple disks ? Standard answer is use RAID arrays. > What about PgSQL 8? It'll include this feature? Not really. While it will support table spaces, the job of combining multiple drives into one large logical drive is the domain of your operating system / underlying hardware. I recommend the LSI MegaRAID series controllers, and a few other folks on the list have had good luck with the Escalade IDE RAID controllers, which aren't the toys most IDE RAID controllers are, they support multiple RAID levels as well as battery backed cache.