Re: Numeric patch to add special-case representations for < 8 bytes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Patric Bechtel <bechtel(at)ipcon(dot)de>
Cc: pgsql-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Numeric patch to add special-case representations for < 8 bytes
Date: 2007-03-02 07:25:51
Message-ID: 2823.1172820351@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Patric Bechtel <bechtel(at)ipcon(dot)de> writes:
> Tom Lane schrieb am 02.03.2007 14:38:
>> Exact decimal fractions are no longer exact when converted to base 2.

> I think multiplying with base 10 until it's a whole number, then saving
> that exponent with it, that's how I understood it.

That hardly seems likely to win in terms of calculation efficiency ---
for example, adding two numbers will now likely require a multiplication
in order to align the values for addition. Having to store the exponent
doesn't sound that great for the original complaint of too much overhead
for short numbers, either...

regards, tom lane

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Simon Riggs 2007-03-02 09:29:11 Re: A little COPY speedup
Previous Message Patric Bechtel 2007-03-02 07:10:47 Re: Numeric patch to add special-case representations for < 8 bytes