| From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
|---|---|
| To: | Kevin Grittner <kgrittn(at)ymail(dot)com> |
| Cc: | Feng Tian <ftian(at)vitessedata(dot)com>, Michael Banck <michael(dot)banck(at)credativ(dot)de>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Jaime Casanova <jaime(at)2ndquadrant(dot)com>, Andres Freund <andres(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Josh Berkus <josh(at)agliodbs(dot)com>, CK Tan <cktan(at)vitessedata(dot)com> |
| Subject: | Re: Let's drop two obsolete features which are bear-traps for novices |
| Date: | 2014-11-04 14:35:14 |
| Message-ID: | CAHyXU0wzx767JYg2JE03fnF-N8ajfhW0jqcr7wwfO+y-cQkaCw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Nov 4, 2014 at 8:16 AM, Kevin Grittner <kgrittn(at)ymail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2014-11-04 14:37:02 | Re: Let's drop two obsolete features which are bear-traps for novices |
| Previous Message | Andreas Karlsson | 2014-11-04 14:35:03 | Re: Let's drop two obsolete features which are bear-traps for novices |