Re: In PG12, query with float calculations is slower than PG11 - Mailing list pgsql-hackers

From Emre Hasegeli
Subject Re: In PG12, query with float calculations is slower than PG11
Date
Msg-id CAE2gYzxnga06ktaqXw4E0K--qAU2pkyvyxPv0CG_3VLR5f7cKg@mail.gmail.com
Whole thread Raw
In response to Re: In PG12, query with float calculations is slower than PG11  (Emre Hasegeli <emre@hasegeli.com>)
Responses Re: In PG12, query with float calculations is slower than PG11
Re: In PG12, query with float calculations is slower than PG11
List pgsql-hackers
> > > > For most places it'd probably end up being easier to read and to
> > > > optimize if we just wrote them as
> > > > if (unlikely(isinf(result)) && !isinf(arg))
> > > >     float_overflow_error();
> > > > and when needed added a
> > > > else if (unlikely(result == 0) && arg1 != 0.0)
> > > >     float_underflow_error();
> > >
> > > +1
> >
> > Cool. Emre, any chance you could write a patch along those lines?
>
> Yes, I am happy to do.  It makes more sense to me too.

How about the one attached?

Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: assert pg_class.relnatts is consistent
Next
From: Tom Lane
Date:
Subject: Re: Small docs bugfix: make it clear what can be used in UPDATE FROM and DELETE USING