Re: [HACKERS] proposal: session server side variables

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: [HACKERS] proposal: session server side variables
Дата
Msg-id CAFj8pRDSB7rYzt8x3cbEBdECN=ci3aMJcX1O5OQB3TECPWDjpQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] proposal: session server side variables  (Fabien COELHO <coelho@cri.ensmp.fr>)
Ответы Re: [HACKERS] proposal: session server side variables  (Fabien COELHO <coelho@cri.ensmp.fr>)
Список pgsql-hackers


2016-12-29 11:42 GMT+01:00 Fabien COELHO <coelho@cri.ensmp.fr>:

yes, I'll do it.

But I'll remove some strange ideas.

Why?

I rather expect that you would comment that you find them strange and argue why: there is no reason to "remove" a concept idea as such at least early in a discussion process...

Why persistent variables?

Because *you* want persistent session variables... I did not invent it, I just removed the "session" word and generalized the concept.

I newer talked about persistent data. I talked about persistent metadata. I really don't propose any possible substitution of tables (relations). I newer did it.

The used terminology is not 100% clean and natural - maybe better name is "global temporary unshared untransactional unrelational storage" - when I use a terminology related to temporary tables. 

I don't see any sense to have two similar storages or two redundant access methods - not in PostgreSQL level.
 

Sometimes one wants to store sets, sometimes one wants to only store value.

Please, one argument. We have tables. What is wrong on tables?

Nothing is wrong as such. Cons arguments are: the syntax is verbose just for one scalar, and the one-row property is currently not easily enforced by pg, AFAIK.

Note that I'm not claiming that it should be implemented, but if some kind of half-persistent variables are implemented, I think it should be consistent with possibly fully-persistent variable as well, even if they are not implemented immediately, or ever.

There is small language barrier :) - I am thinking about features, what we should to implement, not what can be implemented. There is lot of possibilities, that we can find in universe. But only few has technical/practical sense.  

SQL is verbose language - I like it - because it different - the developer have to know when he is working with database, with persistent data. The cost of access to data is significantly higher. When this information is hidden from developer, then the result is terrible slow.

Regards

Pavel

 


Anything what will be persistent will have similar performance like tables.

Yes, sure. It is a different use case. Argue in the wiki!

--
Fabien.

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

Предыдущее
От: Fabien COELHO
Дата:
Сообщение: Re: [HACKERS] proposal: session server side variables
Следующее
От: "Hayes, Patrick"
Дата:
Сообщение: [HACKERS] FW: VACUUM FULL Error