Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508
Дата
Msg-id 26325.1133848960@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508  (Michael Fuhr <mike@fuhr.org>)
Ответы Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508  ("John D. Burger" <john@mitre.org>)
Список pgsql-hackers
Michael Fuhr <mike@fuhr.org> writes:
> On Mon, Dec 05, 2005 at 11:59:10PM -0500, Bruce Momjian wrote:
>> Tom Lane wrote:
>>> The question remains, though, is this computational range good for
>>> anything except demos?
>> 
>> I can say that the extended range is good for finding *printf problems.  ;-)

> Might anybody be calculating permutations or combinations with the
> textbook functions that use factorials?

Hm ... between that, the possible crypto connection, and John's personal
testimony that he actually uses PG for calculations in this range, I'm
starting to lean to the idea that we shouldn't cut the range.

We could get the same 2-byte savings (in fact 3 bytes on average,
considering alignment issues) by implementing a 2-byte length word
format for numeric.  I had originally hoped to do both things to save
an average 5 bytes per numeric, which is starting to get to the point of
actually being interesting ;-).  But maybe we should just do the part
that we can do without removing any user-visible functionality.
        regards, tom lane


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

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: inet to bigint?