Postgres Pro
Downloads
Home   >   mailing lists

Re: scaling postgres - can child tables be in a different tablespace? - Mailing list pgsql-general

From Melvin Davidson
Subject Re: scaling postgres - can child tables be in a different tablespace?
Date
Msg-id CANu8FixojJ434v8BJUPMVY_rdegkwKiJ4y1Lnw7Z9oJj794JRQ@mail.gmail.com
Whole thread Raw
In response to Re: scaling postgres - can child tables be in a different tablespace?  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Responses Re: scaling postgres - can child tables be in a different tablespace?
List pgsql-general
Tree view
As additional advice, to get the best performance, you will want all your tablespaces to be on separate spindles/disks.
EG: disk1/tblspc1
        disk2/tblspc2
        disk3/tblspc3
        ...
        disk99/tblspc99

On Tue, Aug 4, 2015 at 5:31 AM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

pgsql-general by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: scaling postgres - can child tables be in a different tablespace?
Next
From: Adrian Klaver
Date:
Subject: Re: Fwd: postgresql databases disappearing and reappearing and disappearing on localhost - Postgresql x649.3 on Windows 8.1 (64)