PostgreSQL 15 preview - pg_log_backend_memory_contexts 增强, 可打印辅助进程(vacuum, checkpointer等)的内存信息

作者

digoal

日期

2022-01-12

标签

PostgreSQL , pg_log_backend_memory_contexts , 内存上下文

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=790fbda902093c71ae47bff1414799cd716abb80

Enhance pg_log_backend_memory_contexts() for auxiliary processes.  
author  Fujii Masao <fujii@postgresql.org>    
Tue, 11 Jan 2022 14:19:59 +0000 (23:19 +0900)  
committer   Fujii Masao <fujii@postgresql.org>    
Tue, 11 Jan 2022 14:19:59 +0000 (23:19 +0900)  
commit  790fbda902093c71ae47bff1414799cd716abb80  
tree    c880d8ea26d2b6605b3b50faa8a31bf7a80d5d3f    tree  
parent  85c61ba8920ba73500e1518c63795982ee455d14    commit | diff  
Enhance pg_log_backend_memory_contexts() for auxiliary processes.  
Previously pg_log_backend_memory_contexts() could request to  
log the memory contexts of backends, but not of auxiliary processes  
such as checkpointer. This commit enhances the function so that  
it can also send the request to auxiliary processes. It's useful to  
look at the memory contexts of those processes for debugging purpose  
and better understanding of the memory usage pattern of them.  
Note that pg_log_backend_memory_contexts() cannot send the request  
to logger or statistics collector. Because this logging request  
mechanism is based on shared memory but those processes aren't  
connected to that.  
Author: Bharath Rupireddy  
Reviewed-by: Vignesh C, Kyotaro Horiguchi, Fujii Masao  
Discussion: https://postgr.es/m/CALj2ACU1nBzpacOK2q=a65S_4+Oaz_rLTsU1Ri0gf7YUmnmhfQ@mail.gmail.com  
复制

期望 PostgreSQL 增加什么功能?

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

PostgreSQL 解决方案集合

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