本文分享自华为云社区《【防过载检查项】》,作者: 譡里个檔。 1. GUC参数检查 目的:针对不同版本建议设定不同的参数值,当前先检查出来,后续diagnosis会给出建议值 SELECT
split_part((substring(version() from '\((.*)\)')), ' ', 2) AS version,
(EXISTS (SELECT 1 FROM (SELECT count(DISTINCT node_name) AS dn_cnt
FROM pgxc_node WHERE node_type = 'D' AND node_host <> 'localhost' GROUP BY no... 展开更多
精彩评论