From: Erik Wienhold <ewie@ewie.name>
To: Jagmohan Kaintura <jagmohan@tecorelabs.com>
To: noloader@gmail.com
Cc: pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: murmur3 hash binary data migration from Oracle to PostgreSQL
Date: Tue, 25 Apr 2023 13:29:23 +0200 (CEST)
Message-ID: <641544025.615540.1682422163149@office.mailbox.org> (raw)
In-Reply-To: <A35D73BB-2C6E-447D-8391-5FA21D589792@tecorelabs.com>
References: <CAH8yC8=UgYnHiV35OY4vRAqsYaa9BAbbr5gALhR2cnMy6mZyaA@mail.gmail.com>
<A35D73BB-2C6E-447D-8391-5FA21D589792@tecorelabs.com>
> On 25/04/2023 12:44 CEST Jagmohan Kaintura <jagmohan@tecorelabs.com> wrote:
>
> No we want to generate murmur3 format only.
>
> > On 25-Apr-2023, at 8:52 AM, Jeffrey Walton <noloader@gmail.com> wrote:
> >
> > My apologies if I misparsed a couple of statements. I am having
> > trouble determining if you are migrating away from Murmur3.
> >
> > If you are selecting a new digest, then SipHash would be an excellent
> > choice. It was designed to avoid collisions and be fast. Plus it was
> > designed by Jean-Philippe Aumasson and Daniel J. Bernstein. It doesn't
> > get much better than those two fellows.
I don't understand. In your original message you write:
> On 25/04/2023 03:21 CEST Jagmohan Kaintura <jagmohan@tecorelabs.com> wrote:
>
> In Oracle this data is being generated from the Java code and inserted into
> the Oracle database.
Do you generate the hash in Java or in Oracle? I don't know if Oracle
Database provides a MurmurHash function but in Java you could use
apache-commons[0] and change your Java code to also insert the hash (if you
don't already do so).
[0] https://commons.apache.org/proper/commons-codec/apidocs/org/apache/commons/codec/digest/MurmurHash3....
PS: Please don't top post. https://wiki.postgresql.org/wiki/Mailing_Lists#Email_etiquette_mechanics
--
Erik
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: ewie@ewie.name, jagmohan@tecorelabs.com, noloader@gmail.com
Subject: Re: murmur3 hash binary data migration from Oracle to PostgreSQL
In-Reply-To: <641544025.615540.1682422163149@office.mailbox.org>
References: <CAH8yC8=UgYnHiV35OY4vRAqsYaa9BAbbr5gALhR2cnMy6mZyaA@mail.gmail.com> <A35D73BB-2C6E-447D-8391-5FA21D589792@tecorelabs.com> <641544025.615540.1682422163149@office.mailbox.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox