Re: Some improvements to numeric sqrt() and ln()

From: Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Some improvements to numeric sqrt() and ln()
Date: 2020-03-01 19:47:29
Message-ID: CAEZATCVOMC6QpFehBM8oQBa8bx+P1ptWjefgN75iXUnc=jkEQw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, 28 Feb 2020 at 08:15, Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com> wrote:
>
> It's possible that there are further gains to be had in the sqrt()
> algorithm on platforms that support 128-bit integers, but I haven't
> had a chance to investigate that yet.
>

Rebased patch attached, now using 128-bit integers for part of
sqrt_var() on platforms that support them. This turned out to be well
worth it (1.5 to 2 times faster than the previous version if the
result has less than 30 or 40 digits).

Regards,
Dean

Attachment Content-Type Size
numeric-sqrt-v2.patch text/x-patch 21.3 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Noah Misch 2020-03-01 19:56:32 Re: [HACKERS] WAL logging problem in 9.4.3?
Previous Message Tom Lane 2020-03-01 19:42:56 Re: partition routing layering in nodeModifyTable.c