Владимир
Провёл тесты по записи и чтению файла таблицы Postgresql весом 541017 байт
Рейтинг по занятому в итоге месту
272933 zstd-fast-2
272941 zstd-fast-1
272949 gzip-5
272949 zstd-fast-3
272953 lz4
272953 zstd-fast-4
272957 gzip
272957 gzip-8
272965 gzip-9
272965 zstd-14
272973 gzip-2
272973 gzip-4
272973 gzip-6
272973 zstd-5
272973 zstd-9
272977 on
272981 gzip-7
272981 zstd-12
272981 zstd-15
272981 zstd-4
272989 gzip-1
272989 zstd
272989 zstd-1
272989 zstd-17
272989 zstd-18
272989 zstd-19
272993 zstd-fast-5
272997 gzip-3
272997 zstd-3
272997 zstd-8
273005 zstd-10
273005 zstd-11
273013 zstd-16
273013 zstd-2
273013 zstd-7
273021 zstd-6
273029 zstd-13
274985 zstd-fast-6
283061 zstd-fast-7
291305 zstd-fast-8
308045 zstd-fast-10
315405 zstd-fast-9
355113 lzjb
465545 zstd-fast-50
494373 zstd-fast-30
498029 zstd-fast-20
513641 zstd-fast-60
514425 zstd-fast-40
515649 zstd-fast-70
515925 zstd-fast-80
516257 zstd-fast-90
516533 zstd-fast-100
516733 zle
517493 zstd-fast-500
518281 zstd-fast-1000
541017 off
Рейтинг по затраченному времени на запись
zstd-fast-2 0m5,792s
zstd-fast-4 0m5,810s
zstd-fast-6 0m5,825s
zstd-3 0m5,888s
zstd-fast-10 0m5,916s
gzip-1 0m5,929s
gzip-3 0m5,966s
zstd 0m5,977s
zstd-8 0m6,027s
zstd-fast-1 0m6,261s
zstd-1 0m6,676s
zstd-2 0m6,710s
zstd-5 0m6,807s
zstd-fast-9 0m6,815s
gzip-9 0m6,839s
zstd-9 0m6,843s
zstd-fast-3 0m6,860s
on 0m6,919s
lzjb 0m6,931s
zstd-13 0m6,940s
zstd-fast-50 0m6,991s
zstd-fast-7 0m7,244s
zstd-fast-100 0m7,295s
zstd-fast-1000 0m7,575s
zstd-fast-20 0m7,625s
zstd-fast-90 0m7,626s
zstd-10 0m7,662s
zstd-fast-30 0m7,723s
zstd-fast-70 0m7,941s
off 0m7,970s
zstd-fast-60 0m8,660s
zstd-fast-5 0m8,903s
zstd-fast-80 0m9,103s
lz4 0m9,104s
gzip-7 0m9,717s
zstd-fast-8 0m9,818s
zstd-6 0m9,947s
gzip-5 0m10,313s
gzip-8 0m10,591s
zstd-fast-500 0m10,755s
zstd-14 0m10,772s
zstd-fast-40 0m11,190s
zle 0m11,265s
gzip-4 0m11,301s
zstd-4 0m11,403s
gzip-2 0m12,094s
zstd-7 0m12,775s
gzip-6 0m14,020s
gzip 0m18,246s
zstd-12 0m20,912s
zstd-11 0m23,507s
zstd-18 0m28,346s
zstd-16 0m29,338s
zstd-15 0m38,595s
zstd-19 0m50,360s
zstd-17 0m53,334s
Рейтинг по затраченному времени на чтение
zstd-4 0m3,856s
lz4 0m3,883s
zstd-3 0m3,910s
zstd-11 0m3,911s
zstd-fast-8 0m3,936s
zstd-fast-6 0m3,937s
zstd-fast-5 0m3,943s
zstd-fast-2 0m3,983s
zstd-7 0m3,995s
gzip-4 0m4,012s
zstd-fast-3 0m4,025s
gzip 0m4,030s
gzip-5 0m4,082s
lzjb 0m4,107s
zstd-1 0m4,188s
gzip-6 0m4,204s
on 0m4,239s
zstd-fast-4 0m4,506s
zstd-12 0m4,667s
gzip-7 0m5,045s
zstd-fast-1000 0m5,061s
gzip-8 0m5,262s
zstd-fast-100 0m5,282s
zstd-fast-20 0m5,292s
zstd-fast-70 0m5,334s
zstd-fast-10 0m5,419s
gzip-2 0m5,476s
zstd-6 0m5,714s
zle 0m5,732s
zstd-fast-30 0m5,944s
zstd-10 0m6,170s
off 0m6,203s
zstd-fast-500 0m6,378s
zstd-fast-60 0m6,636s
zstd-14 0m6,650s
zstd-fast-40 0m6,916s
zstd-15 0m7,089s
gzip-9 0m7,716s
gzip-3 0m7,818s
zstd-fast-7 0m7,873s
zstd-fast-80 0m7,900s
zstd-16 0m8,115s
zstd-8 0m8,438s
zstd 0m8,515s
zstd-5 0m8,530s
zstd-2 0m8,540s
gzip-1 0m8,634s
zstd-13 0m8,958s
zstd-9 0m9,546s
zstd-fast-90 0m9,556s
zstd-19 0m9,591s
zstd-18 0m9,807s
zstd-17 0m11,449s
zstd-fast-50 0m13,015s
zstd-fast-9 0m14,598s
Тест проводился в SSD пуле с одним vdev mirror из INTEL_SSDSC2KG960G8 с принудительным sync и выключенным arc кешем и ресайзблоком 8кб процессор AMD 3950X