Theo Schlossnagle <[email protected]> writes:
> I'm writing some extension and I have a hot code path that has a lot of
> double (C type) data and needs to output NUMERIC tuple data. The current
> methods I can find in the code to convert sprintf the double to a buffer and
> then invoke the numeric_in function on them. I've profile my stuff and I'm
> spending (wasting) all my time in that conversion. Is there a more efficient
> method of converting a double into a postgres numeric value?
If you're worried about micro-optimization, why are you using NUMERIC at
all? It's no speed demon.
Although you might be able to shave some cycles with a dedicated code
path for this conversion, binary to decimal is fundamentally not cheap.
regards, tom lane
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
