Re: charset/collation in values

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: charset/collation in values
Дата
Msg-id 13961.1099323690@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: charset/collation in values  (Thomas Hallgren <thhal@mailblocks.com>)
Ответы Re: charset/collation in values  (Dennis Bjorklund <db@zigo.dhs.org>)
Список pgsql-hackers
Thomas Hallgren <thhal@mailblocks.com> writes:
> I think the number of charset/collation combinations will be relatively 
> few so perhaps it would be space efficient to maintain a table where 
> each combination is given an oid and have string values store that 
> rather than two separate oid's?

In fact, we should do our best to get the overhead down to 1 or 2 bytes.
Two OIDs (8 bytes) is ridiculous.

I'm not sure if 1 byte is enough or not --- there might be more than 256
charsets/collations to support.  2 ought to be plenty though.
        regards, tom lane


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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: make check error on -HEAD
Следующее
От: Dennis Bjorklund
Дата:
Сообщение: Re: charset/collation in values