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 -- [EMAIL PROTECTED]
----- Original Message ----- From: "Heather Johnson" <[EMAIL PROTECTED]>
To: "Igor Maciel Macaubas" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
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
--
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
