| From: | Stephen Frost <sfrost(at)snowman(dot)net> |
|---|---|
| To: | Igor Maciel Macaubas <igor(at)providerst(dot)com(dot)br> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Does PostgreSQL Stores its database in multiple disks? |
| Date: | 2004-10-02 00:20:53 |
| Message-ID: | 20041002002053.GM21419@ns.snowman.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
* Igor Maciel Macaubas (igor(at)providerst(dot)com(dot)br) wrote:
> 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?
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2004-10-02 00:40:02 | Re: Does PostgreSQL Stores its database in multiple disks? |
| Previous Message | Christian Fowler | 2004-10-01 23:56:31 | Re: Does PostgreSQL Stores its database in multiple disks? |