Re: Does PostgreSQL Stores its database in multiple disks?

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(at)providerst(dot)com(dot)br

----- Original Message -----
From: "Heather Johnson" <hjohnson(at)nypost(dot)com>
To: "Igor Maciel Macaubas" <igor(at)providerst(dot)com(dot)br>
Cc: <pgsql-admin(at)postgresql(dot)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(at)providerst(dot)com(dot)br <mailto:igor(at)providerst(dot)com(dot)br>
>>