PostgreSQL Moves Ahead With Employing Zstd Compression

Written by Michael Larabel in Programming on 13 March 2022 at 06:31 AM EDT. 12 Comments
PROGRAMMING
Back in February PostgreSQL began working on Zstd compression support and now with the latest code changes of the past week, this modern compression algorithm developed at Facebook is now able to play a greater role with this leading open-source database server.

Last month PostgreSQL developers began with the infrastructure changes around handling Zstd compression as an alternative to their LZ4 compression.

The code work in recent days to land includes supporting Zstd base backup compression. Both PostgreSQL client and server-side compression now supports using Zstd.


The other big addition is this commit providing Zstd compression of full-page writes in the WAL. PostgreSQL's Write Ahead Logging now supports Zstd compression of full-page images using Zstd. Currently this is being done at the default Zstd compression level of 3.

As for the performance benefit of the Zstd'ed WAL, "zstd outclasses easily pglz, and is better than LZ4 where one wants to have more compression at the cost of extra CPU but both are good enough in their own scenarios, so the choice between one or the other of these comes to a study of the workload patterns and the schema involved, mainly."

Look for this Zstd compression work and more in the eventual PostgreSQL 15 release.
Related News
About The Author
Michael Larabel

Michael Larabel is the principal author of Phoronix.com and founded the site in 2004 with a focus on enriching the Linux hardware experience. Michael has written more than 20,000 articles covering the state of Linux hardware support, Linux performance, graphics drivers, and other topics. Michael is also the lead developer of the Phoronix Test Suite, Phoromatic, and OpenBenchmarking.org automated benchmarking software. He can be followed via Twitter, LinkedIn, or contacted via MichaelLarabel.com.

Popular News This Week