PostgreSQL 15 preview - pg_basebackup 增强, 支持客户端压缩和压缩比选项

作者

digoal

日期

2022-01-21

标签

PostgreSQL , pg_basebackup

pg_basebackup 增强, 支持客户端压缩和压缩比选项, 目前仅支持客户端压缩, 仅支持gzip压缩算法.

未来有计划支持服务端压缩, 可以节省网络传输量. 看样子我的吐槽要慢慢被实现了? 《DB吐槽大会,第22期 - PG 不支持libpq协议层压缩》

* -z/--gzip is a synonym of --compress=gzip.  
* --compress=NUM implies:  
** --compress=none if NUM = 0.  
** --compress=gzip:NUM if NUM > 0.  
复制

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=5c649fe153367cdab278738ee4aebbfd158e0546

Extend the options of pg_basebackup to control compression  
author  Michael Paquier <michael@paquier.xyz>     
Fri, 21 Jan 2022 02:08:43 +0000 (11:08 +0900)  
committer   Michael Paquier <michael@paquier.xyz>     
Fri, 21 Jan 2022 02:08:43 +0000 (11:08 +0900)  
commit  5c649fe153367cdab278738ee4aebbfd158e0546  
tree    e67b7bd967908edc5f6b8070e980d88fc64dbff3    tree  
parent  512fc2dd790e3e7c35b3af8cd7586aeb25248c6e    commit | diff  
Extend the options of pg_basebackup to control compression  
The option --compress is extended to accept a compression method and an  
optional compression level, as of the grammar METHOD[:LEVEL].  The  
methods currently support are "none" and "gzip", for client-side  
compression.  Any of those methods use only an integer value for the  
compression level, but any method implemented in the future could use  
more specific keywords if necessary.  
This commit keeps the logic backward-compatible.  Hence, the following  
compatibility rules apply for the new format of the option --compress:  
* -z/--gzip is a synonym of --compress=gzip.  
* --compress=NUM implies:  
** --compress=none if NUM = 0.  
** --compress=gzip:NUM if NUM > 0.  
Note that there are also plans to extend more this grammar with  
server-side compression.  
Reviewed-by: Robert Haas, Magnus Hagander, Álvaro Herrera, David  
G. Johnston, Georgios Kokolatos  
Discussion: https://postgr.es/m/Yb3GEgWwcu4wZDuA@paquier.xyz  
复制

期望 PostgreSQL 增加什么功能?

PolarDB for PostgreSQL云原生分布式开源数据库

PostgreSQL 解决方案集合

德哥 / digoal's github - 公益是一辈子的事.