Re: Reducing NUMERIC size for 8.3 - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Reducing NUMERIC size for 8.3
Date
Msg-id 46F92CDB.5010909@dunslane.net
Whole thread Raw
In response to Re: Reducing NUMERIC size for 8.3  (Zdenek Kotala <Zdenek.Kotala@Sun.COM>)
Responses Re: Reducing NUMERIC size for 8.3
List 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 by date:

Previous
From: Zdenek Kotala
Date:
Subject: Re: Reducing NUMERIC size for 8.3
Next
From: Kenneth Marshall
Date:
Subject: Re: Hash index todo list item