Re: Spliting a table/databases between several disks ?

Поиск
Список
Период
Сортировка
От Feite Brekeveld
Тема Re: Spliting a table/databases between several disks ?
Дата
Msg-id 3B097369.98755377@osiris-it.nl
обсуждение исходный текст
Ответ на Spliting a table/databases between several disks ?  (Bo Lorentsen <bl@tod.dk>)
Список 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 по дате отправления:

Предыдущее
От: Abhimanyu_Bhola
Дата:
Сообщение: RE: psql shell problem
Следующее
От: "Denis A. Doroshenko"
Дата:
Сообщение: Re: psql shell problem