Skip site navigation (1) Skip section navigation (2)

Re: per-tablespace random_page_cost/seq_page_cost

From: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Greg Stark <gsstark(at)mit(dot)edu>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andres Freund <andres(at)anarazel(dot)de>, "pgsql-hackers\(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, Josh Berkus <josh(at)agliodbs(dot)com>
Subject: Re: per-tablespace random_page_cost/seq_page_cost
Date: 2009-11-03 12:44:57
Message-ID: 877hu793qu.fsf@hi-media-techno.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Robert Haas <robertmhaas(at)gmail(dot)com> writes:
>> Le 1 nov. 2009 à 13:43, Greg Stark <gsstark(at)mit(dot)edu> a écrit :
>>>
>>> We could have a column for all booleans, a column for all integers,
>>> etc. but that's not really any more normalized than having a single
>>> column for all the types with a rule for how to marshal each value
>>> type.
>>
>> Thé other day, on IRC, someone wanted a dynamic table accepting value in
>> whichever column you name. That would probably mean having a special INSERT
>> INTO which ALTER TABLE ... ADD COLUMN ... for you.
>>
>> Maybe INSERT INTO ... WITH ADD COLUMN OPTION;
>>
>> This sure looks suspicious, but the asking came from another product and it
>> seems that could help here too. Oh and you get text columns I guess, by
>> default...
>
> If you want to start a discussion about a topic that is completely
> unrelated to this one, then please start a new thread.

Auto adding a column on INSERT when it does not exists would help tools
to add columns in there, to avoid having to follow EAV model.

Maybe this property would be tied to the table rather than the INSERT,
though, or maybe we'd be better without it at all. But it's related to
the case at hand, yes.

-- 
Dimitri Fontaine
PostgreSQL DBA, Architecte

In response to

Responses

pgsql-hackers by date

Next:From: Robert HaasDate: 2009-11-03 12:49:34
Subject: Re: per-tablespace random_page_cost/seq_page_cost
Previous:From: Peter EisentrautDate: 2009-11-03 11:31:14
Subject: Re: new version of PQconnectdb was:(Re: [HACKERS] Determining client_encoding from client locale)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group