Re: Memory-comparable Serialization of Data Types

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

Yes, this is exactly what I mean.

On Tue, 11 Feb 2020 at 15:01, Peter Geoghegan <pg(at)bowt(dot)ie> wrote:

> 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 Peter Geoghegan 2020-02-11 20:24:50 Re: pg_locks display of speculative locks is bogus
Previous Message Andres Freund 2020-02-11 20:03:05 pg_locks display of speculative locks is bogus