| From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "David Fetter *EXTERN*" <david(at)fetter(dot)org>, Tatsuo Ishii <ishii(at)postgresql(dot)org> |
| Cc: | "Jim(dot)Nasby(at)BlueTreble(dot)com" <Jim(dot)Nasby(at)BlueTreble(dot)com>, "alvherre(at)2ndquadrant(dot)com" <alvherre(at)2ndquadrant(dot)com>, "michael(dot)banck(at)credativ(dot)de" <michael(dot)banck(at)credativ(dot)de>, "tgl(at)sss(dot)pgh(dot)pa(dot)us" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "andrew(at)dunslane(dot)net" <andrew(at)dunslane(dot)net>, "jaime(at)2ndquadrant(dot)com" <jaime(at)2ndquadrant(dot)com>, "andres(at)2ndquadrant(dot)com" <andres(at)2ndquadrant(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, "josh(at)agliodbs(dot)com" <josh(at)agliodbs(dot)com>, "cktan(at)vitessedata(dot)com" <cktan(at)vitessedata(dot)com> |
| Subject: | Re: Let's drop two obsolete features which are bear-traps for novices |
| Date: | 2014-11-04 08:30:21 |
| Message-ID: | A737B7A37273E048B164557ADEF4A58B17D8BC03@ntex2010i.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
David Fetter wrote:
> On Tue, Nov 04, 2014 at 07:51:06AM +0900, Tatsuo Ishii wrote:
>> Just out of curiosity, why is Oracle's NUMBER (I assume you are
>> talking about this) so fast?
>
> I suspect that what happens is that NUMBER is stored as a native type
> (int2, int4, int8, int16) that depends on its size and then cast to
> the next upward thing as needed, taking any performance hits at that
> point. The documentation hints (38 decimal places) at a 128-bit
> internal representation as the maximum. I don't know what happens
> when you get past what 128 bits can represent.
No, Oracle stores NUMBERs as variable length field (up to 22 bytes),
where the first byte encodes the sign and the comma position and the
remaining bytes encode the digits, each byte representing two digits
in base-100 notation (see Oracle Metalink note 1007641.6).
So it's not so different from PostgreSQL.
No idea why their arithmetic should be faster.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2014-11-04 08:42:31 | Re: BRIN indexes - TRAP: BadArgument |
| Previous Message | Michael Paquier | 2014-11-04 08:29:04 | Re: tracking commit timestamps |