Partitioning tables

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

Partitioning tables

От:
Enrico <scotty@linuxtime.it>
Дата:
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" <scott.marlowe@gmail.com>
Дата:
On 10/9/07, Enrico  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.
FAQ