Re: [HACKERS] COMPRESS VALUES feature request

Поиск
Список
Период
Сортировка
От Marko Tiikkaja
Тема Re: [HACKERS] COMPRESS VALUES feature request
Дата
Msg-id CAL9smLBc5_Gsnw-OC=qw_jGTOuXi7o=r-LXVLqr75UwUNRs5pw@mail.gmail.com
обсуждение исходный текст
Ответ на [HACKERS] COMPRESS VALUES feature request  (Erez Segal <erezsegal@gmail.com>)
Список pgsql-hackers
On Tue, May 9, 2017 at 8:18 PM, Erez Segal <erezsegal@gmail.com> wrote:
In the IRC channel - johto suggested an implementation:

<johto> if you want to get really fancy you could have two columns where only one of set; one would be the value (if reasonably unique) and the other the id (if not)

I only suggested how to do this in an application if one really wants the feature so badly.  I don't think this would fly as a native implementation.
 
I'd like to add that an ENUM can be used instead of the id+lookup table in the 2nd column for non unique values.

An ENUM in postgres *is* an id + lookup table..


.m

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

Предыдущее
От: Ilya Shkuratov
Дата:
Сообщение: Re: [HACKERS] CTE inlining
Следующее
От: Fabien COELHO
Дата:
Сообщение: Re: [HACKERS] proposal psql \gdesc