Re: [HACKERS] Hash Functions - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] Hash Functions
Date
Msg-id 20170515030013.GB30604@momjian.us
Whole thread Raw
In response to Re: [HACKERS] Hash Functions  (Andres Freund <andres@anarazel.de>)
Responses Re: [HACKERS] Hash Functions
List pgsql-hackers
On Sun, May 14, 2017 at 01:06:03PM -0700, Andres Freund wrote:
> On 2017-05-14 15:59:09 -0400, Greg Stark wrote:
> > Personally while I would like to avoid code that actively crashes or
> > fails basic tests on Vax
> 
> I personally vote for simply refusing to run/compile on non-IEEE
> platforms, including VAX.  The benefit of even trying to get that right,
> not to speak of actually testing, seems just not there.

Do we even know that floats are precise enough to determine the
partition.  For example, if you have 6.000000001, is it possible for
that to be 5.9999999 on some systems?  Are IEEE systems all the same for
these values?  I would say we should disallow any approximate date type
for partitioning completely.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] PG 10 release notes
Next
From: Kyotaro HORIGUCHI
Date:
Subject: Re: [HACKERS] Race conditions with WAL sender PID lookups