Re: Move pg_largeobject to a different tablespace *without* turning on system_table_mods.

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Move pg_largeobject to a different tablespace *without* turning on system_table_mods.
Дата
Msg-id CAKFQuwaqhDtL56CiFiaRuSpGDi3HB0WMJvXSe-rODr3w8HzH8A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Move pg_largeobject to a different tablespace *without* turning on system_table_mods.  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: Move pg_largeobject to a different tablespace *without* turning on system_table_mods.  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
Дерево обсуждения
On Wed, Oct 19, 2016 at 9:29 AM, Bruce Momjian <bruce@momjian.us> wrote:
On Tue, Oct 18, 2016 at 04:51:54PM +0200, Andreas Joseph Krogh wrote:
>     > 2. Being able to move pg_largeobject to a different tablespace
>     >    *without* turning on system_table_mods. This is important for
>     >    people storing LOTS of large-objects on separate
>     >    disks (non-SSD) and hence in a different tablespace.

I think an open question is why you would not want to move the other
system tables at the same time you move pg_largeobject.


​I think the theory of having all system tables except LO on SSD storage, and having LO on a less performant device, makes sense.

David J.​
 

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Move pg_largeobject to a different tablespace *without* turning on system_table_mods.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Move pg_largeobject to a different tablespace *without* turning on system_table_mods.