Re: PostrgeSQL vs oracle doing 1 million sqrts am I doing it wrong?

From: James Cloos <cloos(at)jhcloos(dot)com>
To: <pgsql-hackers(at)postgresql(dot)org>
Cc: Shaun Thomas <sthomas(at)optionshouse(dot)com>, Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>, testman1316 <danilo(dot)ramirez(at)hmhco(dot)com>
Subject: Re: PostrgeSQL vs oracle doing 1 million sqrts am I doing it wrong?
Date: 2014-08-06 20:07:07
Message-ID: m3lhr1idqs.fsf@carbon.jhcloos.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>>>>> "ST" == Shaun Thomas <sthomas(at)optionshouse(dot)com> writes:

ST> That said, the documentation here says FLOAT4 is an alias for REAL,
ST> so it's somewhat nonintuitive for FLOAT4 to be so much slower than
ST> FLOAT8, which is an alias for DOUBLE PRECISION.

There are some versions of glibc where doing certain math on double is
faster than doing it on float, depending on how things are compiled.

Maybe this is one of them?

-JimC
--
James Cloos <cloos(at)jhcloos(dot)com> OpenPGP: 0x997A9F17ED7DAEA6

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2014-08-06 20:11:09 Re: B-Tree support function number 3 (strxfrm() optimization)
Previous Message Nicolas Barbier 2014-08-06 20:06:44 Re: Minmax indexes