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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Numeric patch to add special-case representations for < 8 bytes
Дата
Msg-id 2823.1172820351@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Numeric patch to add special-case representations for < 8 bytes  (Patric Bechtel <bechtel@ipcon.de>)
Ответы Re: Numeric patch to add special-case representations for < 8 bytes  (Gregory Stark <stark@enterprisedb.com>)
Список pgsql-patches
Patric Bechtel <bechtel@ipcon.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

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

Предыдущее
От: Patric Bechtel
Дата:
Сообщение: Re: Numeric patch to add special-case representations for < 8 bytes
Следующее
От: "Simon Riggs"
Дата:
Сообщение: Re: A little COPY speedup