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."