Re: New version of money type

From: "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: New version of money type
Date: 2006-09-14 15:12:14
Message-ID: 20060914111214.d9ba7dba.darcy@druid.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, 14 Sep 2006 07:59:07 -0700
"Joshua D. Drake" <jd(at)commandprompt(dot)com> wrote:
> D'Arcy J.M. Cain wrote:
> > For years I have been promising that a 64 bit version of the money type
> > was on the way. Here it is. So far it compiles and I have done some
> > basic testing on it and it seems to work fine. Note that the currency
> > symbol is also dropped on output as well but it is accepted on input.
>
> Not to come down on your hard work, but isn't the money type deprecated?

Not by me. :-)

The biggest argument about the money type is that it has an unrealistic
limit. With this change we can go to almost one hundred thousand
trillion dollars. That should handle even the US federal budget for a
few more years.

The benefit of the money type is speed. Because internal operations
are done on integers they can generally be handled by single CPU ops.
My tests on the 64 bit version show 10% to 25% improvement over numeric
for many operations.

--
D'Arcy J.M. Cain <darcy(at)druid(dot)net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gregory Stark 2006-09-14 15:15:04 Re: CSStorm occurred again by postgreSQL8.2
Previous Message Joshua D. Drake 2006-09-14 14:59:07 Re: New version of money type