Re: Memory-comparable Serialization of Data Types - Mailing list pgsql-hackers

From Shichao Jin
Subject Re: Memory-comparable Serialization of Data Types
Date
Msg-id CABCoBcJ+pgF0ZxSscwX=z+f0RW7jcYTcqosyvy5P4FVReaq2Og@mail.gmail.com
Whole thread Raw
In response to Re: Memory-comparable Serialization of Data Types  (Peter Geoghegan <pg@bowt.ie>)
Responses Re: Memory-comparable Serialization of Data Types
List pgsql-hackers
Yes, this is exactly what I mean.

On Tue, 11 Feb 2020 at 15:01, Peter Geoghegan <pg@bowt.ie> wrote:
On Tue, Feb 11, 2020 at 11:53 AM Shichao Jin <jsc0218@gmail.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

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: pg_locks display of speculative locks is bogus
Next
From: Peter Geoghegan
Date:
Subject: Re: pg_locks display of speculative locks is bogus