Re: TOAST table created for partitioned tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: TOAST table created for partitioned tables
Дата
Msg-id 18167.1516163938@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: TOAST table created for partitioned tables  (Amit Langote <amitlangote09@gmail.com>)
Ответы Re: TOAST table created for partitioned tables
Список pgsql-hackers
Amit Langote <amitlangote09@gmail.com> writes:
> On Wed, Jan 17, 2018 at 5:32 AM, Robert Haas <robertmhaas@gmail.com> wrote:
>> Aargh.  Will apply this patch break pg_upgrade from v10?

> AFAICS, it doesn't.  Partitioned tables that used to have a TOAST
> table in v10 cluster will continue to have it after upgrading.
> Whereas, any partitioned tables created with the patched won't have a
> TOAST table.

Yeah, pg_upgrade already has to cope with cases where the newer version
thinks a table needs a toast table when the older version didn't, or
vice versa.  This looks like it ought to fall into that category.
Not that testing it wouldn't be a good idea.

            regards, tom lane


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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [HACKERS] replace GrantObjectType with ObjectType
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: TOAST table created for partitioned tables