Does PostgreSQL Stores its database in multiple disks?

From: "Igor Maciel Macaubas" <igor(at)providerst(dot)com(dot)br>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Does PostgreSQL Stores its database in multiple disks?
Date: 2004-10-01 21:01:23
Message-ID: 002e01c4a7f9$d1ec0de0$6801a8c0@providerst.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Björn Lundin 2004-10-01 21:09:13 Re: Does PostgreSQL Stores its database in multiple disks?
Previous Message Uwe C. Schroeder 2004-10-01 20:48:41 Re: PLEASE GOD HELP US!