Re: Reducing NUMERIC size for 8.3

From: Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Gregory Stark <stark(at)enterprisedb(dot)com>, PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Reducing NUMERIC size for 8.3
Date: 2007-09-25 15:28:24
Message-ID: 46F92918.9020201@sun.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:
> Gregory Stark <stark(at)enterprisedb(dot)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.

Zdenek

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2007-09-25 15:44:27 Re: Reducing NUMERIC size for 8.3
Previous Message Peter Eisentraut 2007-09-25 14:54:30 pg_resetxlog output clarification