Re: proposal: session server side variables

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
Cc: Craig Ringer <craig(at)2ndquadrant(dot)com>, Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>, Joe Conway <mail(at)joeconway(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: proposal: session server side variables
Date: 2016-12-29 11:07:56
Message-ID: CAFj8pRDSB7rYzt8x3cbEBdECN=ci3aMJcX1O5OQB3TECPWDjpQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

2016-12-29 11:42 GMT+01:00 Fabien COELHO <coelho(at)cri(dot)ensmp(dot)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.
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hayes, Patrick 2016-12-29 12:26:17 FW: VACUUM FULL Error
Previous Message Fabien COELHO 2016-12-29 10:44:46 Re: proposal: session server side variables