Re: murmur3 hash binary data migration from Oracle to PostgreSQL

Поиск
Список
Период
Сортировка
От Jagmohan Kaintura
Тема Re: murmur3 hash binary data migration from Oracle to PostgreSQL
Дата
Msg-id A35D73BB-2C6E-447D-8391-5FA21D589792@tecorelabs.com
обсуждение исходный текст
Ответ на Re: murmur3 hash binary data migration from Oracle to PostgreSQL  (Jeffrey Walton <noloader@gmail.com>)
Ответы Re: murmur3 hash binary data migration from Oracle to PostgreSQL  (Erik Wienhold <ewie@ewie.name>)
Re: murmur3 hash binary data migration from Oracle to PostgreSQL  (Imre Samu <pella.samu@gmail.com>)
Список pgsql-general
Hi ,
No we want to generate murmur3 format only.

BR,
Jagmohan

> On 25-Apr-2023, at 8:52 AM, Jeffrey Walton <noloader@gmail.com> wrote:
>
> On Mon, Apr 24, 2023 at 9:22 PM Jagmohan Kaintura
> <jagmohan@tecorelabs.com> wrote:
>>
>> We are doing Migration from Oracle to PostgreSQL. In SOurce database we have Binary data stored using murmur3
hashingfunction. In Oracle this data is being generated from the Java code and inserted into the Oracle database. 
>>
>> As part of Migration processes the reference data on which this murmur3 is generated is also getting changed while
migratingto PostgreSQL. 
>>
>> In PostgreSQL do we have any mechanism for fetching this murmur3 hash function for any UUID.
>>
>> Please let me know, what ever solution is available for the implementation.
>
> 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.
>
> Jeff



В списке pgsql-general по дате отправления:

Предыдущее
От: Jeffrey Walton
Дата:
Сообщение: Re: murmur3 hash binary data migration from Oracle to PostgreSQL
Следующее
От: Erik Wienhold
Дата:
Сообщение: Re: murmur3 hash binary data migration from Oracle to PostgreSQL