Skip to content

Instantly share code, notes, and snippets.

@Firefishy
Last active November 21, 2025 23:50
Show Gist options
  • Select an option

  • Save Firefishy/3efb405926eec6d6e450c3890dbb717a to your computer and use it in GitHub Desktop.

Select an option

Save Firefishy/3efb405926eec6d6e450c3890dbb717a to your computer and use it in GitHub Desktop.
Compression Level Elapsed(s) Size(MB) Ratio Time Ratio Size
gzip default 827.41 4722 100.00 100.00
zstd default 262.21 4568 31.69 96.74
zstd 1 261.41 4300 31.59 91.06
zstd 2 257.52 4394 31.12 93.05
zstd 3 254.74 4568 30.79 96.74
zstd 4 257.47 4555 31.12 96.46
zstd 5 297.04 4278 35.90 90.60
zstd 6 432.36 4146 52.25 87.80
zstd 7 517.11 4115 62.50 87.15
zstd 8 665.26 3872 80.40 82.00
zstd 9 707.99 3879 85.57 82.15
zstd 10 1034.67 3856 125.05 81.66
zstd 11 1545.89 3833 186.83 81.17
zstd 12 1561.49 3833 188.72 81.17
@Firefishy

Firefishy commented Aug 11, 2025

Copy link
Copy Markdown
Author

Decompression of zstd is 2x faster than gzip, regardless of zstd level.

@Firefishy

Copy link
Copy Markdown
Author

The compression was specified using eg: pg_dump --compress=zstd:5

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment