Re: Zedstore - compressed in-core columnar storage - Mailing list pgsql-hackers

From Andreas Karlsson
Subject Re: Zedstore - compressed in-core columnar storage
Date
Msg-id 93222d26-2141-acf2-61ef-3127f57e80e6@proxel.se
Whole thread Raw
In response to Re: Zedstore - compressed in-core columnar storage  (Konstantin Knizhnik <k.knizhnik@postgrespro.ru>)
Responses Re: Zedstore - compressed in-core columnar storage
List pgsql-hackers

On 4/11/19 10:46 AM, Konstantin Knizhnik wrote:

This my results of compressing pbench data using different compressors:

ConfigurationSize (Gb)Time (sec)
no compression
15.3192
zlib (default level) 2.37 284
zlib (best speed) 2.43191
postgres internal lz 3.89 214
lz44.12
95
snappy5.1899
lzfse2.801099
(apple) 2.80 1099
1.69125


You see that zstd provides almost 2 times better compression ration and almost at the same speed.


What is "(apple) 2.80 1099"? Was that intended to be zstd?

Andreas

pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Zedstore - compressed in-core columnar storage
Next
From: Michael Paquier
Date:
Subject: Re: REINDEX CONCURRENTLY 2.0