Hi,
On 2019-04-14 18:36:18 +0200, Tomas Vondra wrote:
> I think those comparisons are cute and we did a fair amount of them when
> considering a drop-in replacement for pglz, but ultimately it might be a
> bit pointless because:
>
> (a) it very much depends on the dataset (one algorithm may work great on
> one type of data, suck on another)
>
> (b) different systems may require different trade-offs (high ingestion
> rate vs. best compression ratio)
>
> (c) decompression speed may be much more important
>
> What I'm trying to say is that we shouldn't obsess about picking one
> particular algorithm too much, because it's entirely pointless. Instead,
> we should probably design the system to support different compression
> algorithms, ideally at column level.
I think we still need to pick a default algorithm, and realistically
that's going to be used by like 95% of the users.
Greetings,
Andres Freund