Re: double and numeric conversion - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: double and numeric conversion
Date
Msg-id 162867791003030302j3f14d29bx1b0d65c54ba26561@mail.gmail.com
Whole thread Raw
In response to Re: double and numeric conversion  (Yeb Havinga <yebhavinga@gmail.com>)
List pgsql-hackers
2010/3/3 Yeb Havinga <yebhavinga@gmail.com>:
> Pavel Stehule wrote:
>>
>> 2010/3/3 Yeb Havinga <yebhavinga@gmail.com>:
>>
>>>
>>> Theo Schlossnagle wrote:
>>>
>>>>
>>>> I didn't look deeply at the postgres internals to see if there was a way
>>>> to do double -> numeric and integer-types -> numeric without
>>>> intermediary
>>>> string format.  If that sort of thing is easy to leverage, I'd be happy
>>>> to
>>>> share the code.
>>>>
>>>>
>>>
>>> I think your code could be valuable for postgres on the fact alone that
>>> it
>>> is almost twice as fast, and probably easy to integrate and unit test. We
>>> make heavy use of the numeric data type, so I'm very interested!
>>>
>>
>> I did some test and numeric->double is about 5% faster than
>> numeric->string->double (on my PC)
>>
>
> numeric_to_double_no_overflow() also uses string as intermediate format.
>
> Theo's conversions are the converse, from double to numeric, and do not use
> string as intermediate format (if I understand it correct). (where
> float8_numeric
> http://doxygen.postgresql.org/backend_2utils_2adt_2numeric_8c.html#2de7f65c8de4b65dad441e77ea1bf402
> does)
>

aha - it is reason why time similar

Pavel

> regards
> Yeb Havinga
>
>


pgsql-hackers by date:

Previous
From: Yeb Havinga
Date:
Subject: Re: double and numeric conversion
Next
From: Andrew Dunstan
Date:
Subject: Re: USE_LIBXSLT in MSVC builds