From: | Erik Wienhold <ewie(at)ewie(dot)name> |
---|---|
To: | Jagmohan Kaintura <jagmohan(at)tecorelabs(dot)com>, noloader(at)gmail(dot)com |
Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: murmur3 hash binary data migration from Oracle to PostgreSQL |
Date: | 2023-04-25 11:29:23 |
Message-ID: | 641544025.615540.1682422163149@office.mailbox.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> On 25/04/2023 12:44 CEST Jagmohan Kaintura <jagmohan(at)tecorelabs(dot)com> wrote:
>
> No we want to generate murmur3 format only.
>
> > On 25-Apr-2023, at 8:52 AM, Jeffrey Walton <noloader(at)gmail(dot)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(at)tecorelabs(dot)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).
PS: Please don't top post. https://wiki.postgresql.org/wiki/Mailing_Lists#Email_etiquette_mechanics
--
Erik
From | Date | Subject | |
---|---|---|---|
Next Message | gzh | 2023-04-25 11:34:56 | Re: psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist |
Previous Message | Jagmohan Kaintura | 2023-04-25 10:44:27 | Re: murmur3 hash binary data migration from Oracle to PostgreSQL |