Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOAST table does not exist

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOAST table does not exist
Дата
Msg-id
12731.1516897774@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
[PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOAST table does not exist Nikolay Shaplov <dhyan@nataraj.su>
Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOASTtable does not exist Robert Haas <robertmhaas@gmail.com>
Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOAST table does not exist Tom Lane <tgl@sss.pgh.pa.us>
Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOAST table does not exist Nikolay Shaplov <dhyan@nataraj.su>
Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOASTtable does not exist Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOAST table does not exist Nikolay Shaplov <dhyan@nataraj.su>
Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOASTtable does not exist Robert Haas <robertmhaas@gmail.com>
Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOASTtable does not exist Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOAST table does not exist Tom Lane <tgl@sss.pgh.pa.us>
Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOASTtable does not exist Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOAST table does not exist Tom Lane <tgl@sss.pgh.pa.us>
Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOAST table does not exist Nikolay Shaplov <dhyan@nataraj.su>
Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOASTtable does not exist Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOASTtable does not exist David Steele <david@pgmasters.net>
Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOAST table does not exist Nikolay Shaplov <dhyan@nataraj.su>
Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOASTtable does not exist Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOASTtable does not exist David Steele <david@pgmasters.net>
Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOASTtable does not exist Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Alvaro Herrera  writes:
> Tom Lane wrote:
>> Well, maybe the right answer is to address that.  It's clear to me
>> why that would happen if we store these things as reloptions on the
>> toast table, but can't they be stored on the parent table?

> Actually, Nikolay provided a possible solution: if you execute ALTER
> TABLE SET (toast.foobar = xyz), and a toast table doesn't exist, create
> one at that point.

That adds a lot of overhead if you never actually need the toast table.

Still, maybe it's an appropriate amount of effort compared to the size
of the use-case for this.

			regards, tom lane

В списке pgsql-hackers по дате отправления
От: Peter Eisentraut
Дата:
Сообщение: Re: Doc tweak for huge_pages?
От: Arthur Zakirov
Дата:
FAQ