Re: New version of money type - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: New version of money type
Date
Msg-id 20060928164424.GX24675@kenobi.snowman.net
Whole thread Raw
In response to Re: New version of money type  ("Luke Lonergan" <LLonergan@greenplum.com>)
Responses Re: New version of money type  ("Luke Lonergan" <llonergan@greenplum.com>)
Re: New version of money type  ("D'Arcy J.M. Cain" <darcy@druid.net>)
List pgsql-hackers
* Luke Lonergan (LLonergan@greenplum.com) wrote:
> Though this may be the kiss of death, I favor a 64 bit float version of money.  It's more terse than numeric and a
*lot*faster when performing numeric operations because it would use a cpu intrinsic operand.
 

What about just having a numeric64, or changing numeric to support
moving to 64bit sizes when necessary and supported by the platform?
Exactly how much faster would it *really* be?  Have you tested it?  At
what point does it become a 'winning' change?

I'm not sure about 'money' in general but these claims of great
performance improvments over numeric just don't fly so easily with me.
numeric isn't all *that* much slower than regular old integer in the
tests that I've done.
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: "Luke Lonergan"
Date:
Subject: Re: New version of money type
Next
From: Mark Wong
Date:
Subject: Re: Bitmap index status