Re: Reducing data type space usage

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: Reducing data type space usage
Дата
Msg-id 450C15B2.1040608@dunslane.net
обсуждение исходный текст
Ответ на Re: Reducing data type space usage  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Reducing data type space usage  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers

Tom Lane wrote:
> To review: Bruce is
> proposing a var-length type structure with the properties
>
>     first byte 0xxxxxxx  ---- field length 1 byte, exactly that value
>     first byte 1xxxxxxx  ---- xxxxxxx data bytes follow
>
> This can support *any* stored value from zero to 127 bytes long.
> We can imagine creating new datatypes "short varchar" and "short char",
> and then having the parser silently substitute these types for varchar(N)
> or char(N) whenever N <= 127 / max_encoding_length.  Add some
> appropriate implicit casts to convert these to the normal varlena types
> for computation, and away you go.  No breakage of any existing
> datatype-specific code, just a few additions in places like
> heap_form_tuple.
>
>     
>   

I like this scheme a lot - maximum bang for buck.

Is there any chance we can do it transparently, without exposing new 
types? It is in effect an implementation detail ISTM, and ideally the 
user would not need to have any knowledge of it.

cheers

andrew


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Reducing data type space usage
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Reducing data type space usage