Re: Partitioning tables

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: info(at)enricopirozzi(dot)info
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Partitioning tables
Date: 2007-10-09 14:35:03
Message-ID: dcc563d10710090735x214c2529g2f5e11b137ffab0a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 10/9/07, Enrico <scotty(at)linuxtime(dot)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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Carol Walter 2007-10-09 16:34:49 pghotbackup
Previous Message Enrico 2007-10-09 14:02:06 Partitioning tables