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

From Greg Stark
Subject Re: [HACKERS] Hash Functions
Date
Msg-id CAM-w4HP_J7zZpTAWTPaz01gPpU8oKPz0WsLHcNJS72vW=w6-=w@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Hash Functions  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: [HACKERS] Hash Functions  (Andres Freund <andres@anarazel.de>)
Re: [HACKERS] Hash Functions  (Thomas Munro <thomas.munro@enterprisedb.com>)
List pgsql-hackers
On 13 May 2017 at 10:29, Robert Haas <robertmhaas@gmail.com> wrote:
> - Floats.  There may be different representations in use on different
> hardware, which could be a problem.  Tom didn't answer my question
> about whether any even-vaguely-modern hardware is still using non-IEEE
> floats, which I suspect means that the answer is "no".

Fwiw the answer to that is certainly no. The only caveat is that some
platforms have not entirely complete implementations of IEEE missing
corner cases such as denormalized values but I don't think that would
be something that would be changed with a different hash function
though.

Personally while I would like to avoid code that actively crashes or
fails basic tests on Vax even I don't think we need to worry about
replication or federated queries in a heterogeneous environment where
some servers are Vaxen and some are modern hardware. That seems a bit
far-fetched.

-- 
greg



pgsql-hackers by date:

Previous
From: Christopher Allan Webber
Date:
Subject: Re: [HACKERS] postgres 9.6.2 update breakage
Next
From: Pavel Stehule
Date:
Subject: Re: [HACKERS] issue: record or row variable cannot be part ofmultiple-item INTO list