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.