Re: Does PostgreSQL Stores its database in multiple disks? - Mailing list pgsql-admin

From Stephen Frost
Subject Re: Does PostgreSQL Stores its database in multiple disks?
Date
Msg-id 20041002002053.GM21419@ns.snowman.net
Whole thread Raw
In response to Does PostgreSQL Stores its database in multiple disks?  ("Igor Maciel Macaubas" <igor@providerst.com.br>)
List pgsql-admin
* Igor Maciel Macaubas (igor@providerst.com.br) wrote:
> I have a PostgreSQL server, running 7.4.2, that will store a really large amount of data (200GB) being migrated from
anOracle database. I have a machine with two 120GB Ultra ATA IDE disks, and I'd like to know if PostgreSQL could split
itover 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?

An alternative might be to use some kind of LVM (such as device
mapper/LVM2 under Linux) to combine the two disks into one logical
device.

    Stephen

Attachment

pgsql-admin by date:

Previous
From: Christian Fowler
Date:
Subject: Re: Does PostgreSQL Stores its database in multiple disks?
Next
From: "Scott Marlowe"
Date:
Subject: Re: Does PostgreSQL Stores its database in multiple disks?