Re: Memory-comparable Serialization of Data Types

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: Shichao Jin <jsc0218(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Memory-comparable Serialization of Data Types
Date: 2020-02-11 20:00:51
Message-ID: CAH2-Wzm5GLWGMELAKCuXM0=fR622LtqZzMJ9nC2vhEJrOSGXqw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Feb 11, 2020 at 11:53 AM Shichao Jin <jsc0218(at)gmail(dot)com> wrote:
> We are currently integrating LSM-tree based storage engine RocksDB into Postgres. I am wondering is there any function that serialize data types in memory-comparable format, similar to MySQL and MariaDB. With that kind of function, we can directly store the serialized format in the storage engine and compare them in the storage engine level instead of deserializing data and comparing in the upper level.

Do you mean a format that can perform Index comparisons using a
memcmp() rather than per-datatype comparison code?

--
Peter Geoghegan

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2020-02-11 20:03:05 pg_locks display of speculative locks is bogus
Previous Message Shichao Jin 2020-02-11 19:52:52 Memory-comparable Serialization of Data Types