Re: scaling postgres - can child tables be in a different tablespace?

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "'Chris Withers *EXTERN*'" <chris(at)simplistix(dot)co(dot)uk>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: scaling postgres - can child tables be in a different tablespace?
Date: 2015-08-04 09:31:33
Message-ID: A737B7A37273E048B164557ADEF4A58B50F8C0AC@ntex2010i.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Chris Withers wrote:
> This raises an interesting question: can a child table be in a different
> tablespace to its parent and other children of that parent?

Yes.

Inheritance is a logical concept and is independent of physical placement.

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Melvin Davidson 2015-08-04 13:14:04 Re: scaling postgres - can child tables be in a different tablespace?
Previous Message dinesh kumar 2015-08-04 09:07:11 Re: Fwd: postgresql databases disappearing and reappearing and disappearing on localhost - Postgresql x649.3 on Windows 8.1 (64)