Re: Reducing NUMERIC size for 8.3

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: Reducing NUMERIC size for 8.3
Дата
Msg-id 46F92CDB.5010909@dunslane.net
обсуждение исходный текст
Ответ на Re: Reducing NUMERIC size for 8.3  (Zdenek Kotala <Zdenek.Kotala@Sun.COM>)
Ответы Re: Reducing NUMERIC size for 8.3  (Zdenek.Kotala@Sun.COM)
Список pgsql-hackers

Zdenek Kotala wrote:
> Tom Lane wrote:
>> Gregory Stark <stark@enterprisedb.com> writes:
>>> We previously discussed compressing the numeric data type for small 
>>> values:
>>> http://archives.postgresql.org/pgsql-hackers/2007-06/msg00715.php
>>
>>> We didn't do this for 8.3 but in any case Tom did suggest we ought 
>>> to reverse
>>> the weight and sign/dscale so we could do this sometime without 
>>> introducing
>>> another incompatibility.
>>
>> I had forgotten about that, but it does seem like a good idea to do 
>> it now.
>> Any objections?
>
> For in-place upgrade purpose It would be good change also OID for 
> numeric type and preserve current OID for current implementation on 
> updated system.
>
>
>        

If we want to get into that game we need a better way of allocating 
Oids. Right now anything not currently used is liable to be grabbed, so 
there's a high risk of reuse.

cheers

andrew


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

Предыдущее
От: Zdenek Kotala
Дата:
Сообщение: Re: Reducing NUMERIC size for 8.3
Следующее
От: Kenneth Marshall
Дата:
Сообщение: Re: Hash index todo list item