Thread: Partitioning tables

Partitioning tables

From
Enrico
Date:
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

From
"Scott Marlowe"
Date:
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.