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