zstd compression for pg_dump
Justin Pryzby <pryzby@telsasoft.com>
From: Justin Pryzby <pryzby@telsasoft.com>
To: pgsql-hackers@postgresql.org
Date: 2020-12-21T19:49:24Z
Lists: pgsql-hackers
Attachments
- 0001-fix-pre-existing-docs-comments.patch (text/x-diff)
I found that our largest tables are 40% smaller and 20% faster to pipe pg_dump -Fc -Z0 |zstd relative to native zlib So I wondered how much better when integrated in pg_dump, and found that there's some additional improvement, but a big disadvantage of piping through zstd is that it's not identified as a PGDMP file, and, /usr/bin/file on centos7 fails to even identify zstd by its magic number.. I looked for previous discussion about alternate compressions, but didn't find anything for pg_dump. -- Justin
Commits
-
pg_dump: Add support for zstd compression
- 84adc8e20f54 16.0 landed