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

Поиск
Список
Период
Сортировка
От Melvin Davidson
Тема Re: scaling postgres - can child tables be in a different tablespace?
Дата
Msg-id CANu8FixojJ434v8BJUPMVY_rdegkwKiJ4y1Lnw7Z9oJj794JRQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: scaling postgres - can child tables be in a different tablespace?  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Ответы Re: scaling postgres - can child tables be in a different tablespace?
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Albe Laurenz
Дата:
Сообщение: Re: scaling postgres - can child tables be in a different tablespace?
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Fwd: postgresql databases disappearing and reappearing and disappearing on localhost - Postgresql x649.3 on Windows 8.1 (64)