pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Igor Maciel Macaubas <igor@providerst.com.br>
To: Heather Johnson <hjohnson@nypost.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Does PostgreSQL Stores its database in multiple disks?
Date: Fri, 1 Oct 2004 18:28:57 -0300
Message-ID: <000e01c4a7fd$ac39a540$6801a8c0@providerst.local> (raw)
References: <002e01c4a7f9$d1ec0de0$6801a8c0@providerst.local>
	<415DC978.9030209@nypost.com>

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" <hjohnson@nypost.com>
To: "Igor Maciel Macaubas" <igor@providerst.com.br>
Cc: <pgsql-admin@postgresql.org>
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 <mailto:igor@providerst.com.br>
>> 




view thread (8+ messages)  latest in thread

Message-ID: <000e01c4a7fd$ac39a540$6801a8c0@providerst.local>
Permalink:  ../000e01c4a7fd$ac39a540$6801a8c0@providerst.local/
Also on:    postgresql.org/message-id/000e01c4a7fd$ac39a540$6801a8c0@providerst.local

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: igor@providerst.com.br, hjohnson@nypost.com
  Subject: Re: Does PostgreSQL Stores its database in multiple disks?
  In-Reply-To: <000e01c4a7fd$ac39a540$6801a8c0@providerst.local>
  References: <002e01c4a7f9$d1ec0de0$6801a8c0@providerst.local> <415DC978.9030209@nypost.com> <000e01c4a7fd$ac39a540$6801a8c0@providerst.local>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox