Re: Spliting a table/databases between several disks ? - Mailing list pgsql-general

From Feite Brekeveld
Subject Re: Spliting a table/databases between several disks ?
Date
Msg-id 3B097369.98755377@osiris-it.nl
Whole thread Raw
In response to Spliting a table/databases between several disks ?  (Bo Lorentsen <bl@tod.dk>)
List pgsql-general
Bo Lorentsen wrote:

> Hi ...
>
> I have been planning using the PostgreSQL database using a somhow large
> database (and therefor some large tables). While doing this i really
> like to know if it is possible to split data in a database og even a
> table between several disks ?

If you have databases that large that they don't fit on a single disk
(nowdays 75 Gb !) you definitely should consider to look for a RAID level 5
solution. For instance using 7 disks of which 2 hot-spares. With the 75 G
disks you would get to about 350 G diskspace which is logically seen as one
partition.

>
>
> I have tried to look into this problem, and it looks like it is possible
> to make several databases using different locations, but as I can see it
> It is not possible to use databases together.
>
> It would be --- Hmmm, funny to be able to fx. enherit a table from one
> database to another, as this could help.
>
> I hope I'm not too much off track.
>
> Regards
>
> /BL
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

--
Feite Brekeveld
feite.brekeveld@osiris-it.nl



pgsql-general by date:

Previous
From: Abhimanyu_Bhola
Date:
Subject: RE: psql shell problem
Next
From: "Denis A. Doroshenko"
Date:
Subject: Re: psql shell problem