Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOAST table does not exist - Mailing list pgsql-hackers

From Nikolay Shaplov
Subject Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOAST table does not exist
Date
Msg-id 1554110.70SQF4eQMf@x200m
Whole thread Raw
In response to Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOAST table does not exist  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOASTtable does not exist
Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOASTtable does not exist
List pgsql-hackers
В письме от 25 января 2018 11:29:34 пользователь Tom Lane написал:
> Alvaro Herrera <alvherre@alvh.no-ip.org> 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.
I think this overhead case is not that terrible if it is properly warned ;-)

> Still, maybe it's an appropriate amount of effort compared to the size
> of the use-case for this.
If you came to some final conclustion, please close the commiffest item with
"Return with feedback" resolution, and I write another patch...

--
Do code for fun.
Attachment

pgsql-hackers by date:

Previous
From: Luke Cowell
Date:
Subject: Re: Possible performance regression with pg_dump of a large number ofrelations
Next
From: Daniel Gustafsson
Date:
Subject: Re: CONSTANT/NOT NULL/initializer properties for plpgsql record variables