On Thu, Nov 12, 2020 at 4:40 PM Tomas Vondra <tomas.von...@enterprisedb.com> wrote: > master zedstore/pglz zedstore/lz4 > ------------------------------------------------- > copy 1855 68092 2131 > dump 751 905 811 > > And the size of the lineitem table (as shown by \d+) is: > > master: 64GB > zedstore/pglz: 51GB > zedstore/lz4: 20GB > > It's mostly expected lz4 beats pglz in performance and compression > ratio, but this seems a bit too extreme I guess. Per past benchmarks > (e.g. [1] and [2]) the difference in compression/decompression time > should be maybe 1-2x or something like that, not 35x like here.
I can't speak to the ratio, but in basic backup/restore scenarios pglz is absolutely killing me; Performance is just awful; we are cpubound in backups throughout the department. Installations defaulting to plgz will make this feature show very poorly. merlin