PostgreSQL 15 preview - 增加逻辑订阅端worker统计信息视图 pg_stat_subscription_workers

作者

digoal

日期

2021-11-30

标签

PostgreSQL , pg_stat_subscription_workers

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=8d74fc96db5fd547e077bf9bf4c3b67f821d71cd

Add a view to show the stats of subscription workers. master github/master  
author  Amit Kapila <akapila@postgresql.org>      
Tue, 30 Nov 2021 03:24:30 +0000 (08:54 +0530)  
committer   Amit Kapila <akapila@postgresql.org>      
Tue, 30 Nov 2021 03:24:30 +0000 (08:54 +0530)  
commit  8d74fc96db5fd547e077bf9bf4c3b67f821d71cd  
tree    3037345a7edabd025edcc5d9b431fb14f780e817    tree  
parent  98105e53e0ab472b7721a3e8d7b9f1750a635120    commit | diff  
Add a view to show the stats of subscription workers.  
This commit adds a new system view pg_stat_subscription_workers, that  
shows information about any errors which occur during the application of  
logical replication changes as well as during performing initial table  
synchronization. The subscription statistics entries are removed when the  
corresponding subscription is removed.  
It also adds an SQL function pg_stat_reset_subscription_worker() to reset  
single subscription errors.  
The contents of this view can be used by an upcoming patch that skips the  
particular transaction that conflicts with the existing data on the  
subscriber.  
This view can be extended in the future to track other xact related  
statistics like the number of xacts committed/aborted for subscription  
workers.  
Author: Masahiko Sawada  
Reviewed-by: Greg Nancarrow, Hou Zhijie, Tang Haiying, Vignesh C, Dilip Kumar, Takamichi Osumi, Amit Kapila  
Discussion: https://postgr.es/m/CAD21AoDeScrsHhLyEPYqN3sydg6PxAPVBboK=30xJfUVihNZDA@mail.gmail.com  
复制

期望 PostgreSQL 增加什么功能?

类似Oracle RAC架构的PostgreSQL已开源: 阿里云PolarDB for PostgreSQL云原生分布式开源数据库!

PostgreSQL 解决方案集合

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