Обсуждение: Partitioning tables

Поиск
Список
Период
Сортировка

Partitioning tables

От
Enrico
Дата:
Hi all,
Is it possible to partition a large table in differtent disks?

For example

names from A to K in one disk and from L to Z in another.

Regards
Enrico

--
Enrico Pirozzi
Web: http://www.enricopirozzi.info
E-Mail: info@enricopirozzi.info
Skype: sscotty71

Re: Partitioning tables

От
"Scott Marlowe"
Дата:
On 10/9/07, Enrico <scotty@linuxtime.it> wrote:
> Hi all,
> Is it possible to partition a large table in differtent disks?
>
> For example
>
> names from A to K in one disk and from L to Z in another.

Yep.

Just create file systems belonging to the postgres super user, create
tablespaces on those file systems, and then create your inherited
tables on those tablespaces as appropriate.