Re: Let's drop two obsolete features which are bear-traps for novices - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: Let's drop two obsolete features which are bear-traps for novices
Date
Msg-id CAHyXU0wzx767JYg2JE03fnF-N8ajfhW0jqcr7wwfO+y-cQkaCw@mail.gmail.com
Whole thread Raw
In response to Re: Let's drop two obsolete features which are bear-traps for novices  (Kevin Grittner <kgrittn@ymail.com>)
List pgsql-hackers
On Tue, Nov 4, 2014 at 8:16 AM, Kevin Grittner <kgrittn@ymail.com> wrote:
> In any event, I'm against removing or re-deprecating the money
> type.  There are some problems with money; there are other problems
> with numeric.  If the docs are failing to make the trade-offs
> clear, we should fix the docs.  And we can always look at improving
> either or both types.  The fact that numeric is 5x to 20x slower
> than money in important applications, combined with the fact that
> it performs far worse than a similar type in another product,
> suggest that numeric could stand a serious optimization pass.

Money should stay.  It is the only fixed point integer based numeric
that comes with the database.  Should a non locale dependent fixed
point type that offers the same performance come along, then you have
a good argument to deprecate.

numeric is definitely a dog which the fundamental problem IMNSHO.  I'm
guessing optimization paths are going to revolve around utilizing
binary integer ops in cases where it's known to be safe to do so.

merlin



pgsql-hackers by date:

Previous
From: Andreas Karlsson
Date:
Subject: Re: Let's drop two obsolete features which are bear-traps for novices
Next
From: Andrew Dunstan
Date:
Subject: Re: Let's drop two obsolete features which are bear-traps for novices