节点segment问题

请教一个问题，今天我们的数据库异常，active query数量激增，原因是有一个segment自动重启了。我的疑问是为什么page in/out会激增？不应该是大量active query会导致gp master 节点的内存升高？谢谢您

请教一个问题，今天我们的数据库异常，active query数量激增，原因是有一个segment自动重启了。我的疑问是为什么page in/out会激增？不应该是大量active query会导致gp master 节点的内存升高？谢谢您本问题来自云栖社区【PostgreSQL技术进阶社群】。https://yq.aliyun.com/articles/690084 点击链接欢迎加入社区大社群。

greenplum数据节点segment个数问题

在一台数据节点上部署几个segment合适？应该以那些参数来做参考，从而达到资源的最大化利用的同时对性能影响也很小

节点更多"segment"相关

.greenplum节点segment

节点问题segment相关内容

.问题flink节点 .节点购买问题 .问题节点升级 .问题节点优先级 .问题提交节点 .不同节点问题 .问题节点数据库 .节点插件问题 .html问题节点 .问题节点海外 .使用节点问题 .greenplum节点问题 .节点问题本地

您可能感兴趣

.java节点 ..xml节点 .xml节点 .云服务器节点 .云服务节点 .问题节点 .什么是节点 ..net节点

{"optioninfo":{"dynamic":"ture","static":"true"},"simplifiedDisplay":"newEdition","newCard":[{"ifIcon":"img","link":"https://img.alicdn.com/tfs/TB1XY8hGYr1gK0jSZFDXXb9yVXa-1740-328.png","icon":"","iconImg":"https://img.alicdn.com/tfs/TB1Lds12ET1gK0jSZFrXXcNCXXa-200-200.png","contentLink":"https://www.aliyun.com/product/ens","title":"边缘节点服务 ENS","des":"边缘节点服务（Edge Node Service, ENS）基于运营商边缘节点和网络构建，一站式提供“融合、开放、联动、弹性”的分布式算力资源，帮助用户业务下沉至运营商侧边缘，有效降低计算时延和成本。","link1":"https://ens.console.aliyun.com/?spm=5176.14468259.nav-right.159.21017341mrNdLP","btn1":"产品控制台","link2":"https://help.aliyun.com/document_detail/63848.html?spm=5176.cnens.0.0.184c42fbEOCZiM","btn2":"产品价格","btn3":"产品文档","link3":"https://help.aliyun.com/document_detail/63837.html?spm=5176.cnens.0.0.184c42fbEOCZiM","infoGroup":[{"infoName":"产品入门","infoContent":{"firstContentLink":"https://help.aliyun.com/document_detail/63855.html?spm=5176.cnens.0.0.184c42fbEOCZiM","firstContentName":"产品快速入门","lastContentName":"常见问题","lastContentLink":"https://help.aliyun.com/knowledge_detail/64663.html?spm=5176.cnens.0.0.184c42fbEOCZiM"}},{"infoName":"最新动态","infoContent":{"firstContentLink":"https://help.aliyun.com/document_detail/163248.html?spm=a2c4g.11186623.6.542.4cbf545eQNvlde","firstContentName":"产品最新动态","lastContentLink":"","lastContentName":""}}]}],"card":[],"search":[],"infoCard":[],"title":{"mainTitle":"mPaaS","subtitle":"源自于支付宝小程序框架，亿级线上业务体量的锤炼，安全性媲美支付宝原生能力。不仅面向自有 App 投放小程序，更可快速构建打包，覆盖支付宝、淘宝、钉钉等应用。","linkUrl":"https://www.aliyun.com/product/mobilepaas/mpaas-miniprogram","btnText":"查看详情"},"visual":{"topbg":"https://img.alicdn.com/tfs/TB1bQuBIYH1gK0jSZFwXXc7aXXa-3840-740.gif","icon":"","textColor":"dark"},"dataList":[{"summary":"啦啦啦","author":"wuwu","linksUrl":"#"}],"sceneCard":[],"txt":[]}

{"$env":{"JSON":{}},"$page":{"env":"production"},"$context":{"optioninfo":{"dynamic":"ture","static":"true"},"simplifiedDisplay":"newEdition","newCard":[{"ifIcon":"img","link":"https://img.alicdn.com/tfs/TB1XY8hGYr1gK0jSZFDXXb9yVXa-1740-328.png","icon":"","iconImg":"https://img.alicdn.com/tfs/TB1Lds12ET1gK0jSZFrXXcNCXXa-200-200.png","contentLink":"https://www.aliyun.com/product/ens","title":"边缘节点服务 ENS","des":"边缘节点服务（Edge Node Service, ENS）基于运营商边缘节点和网络构建，一站式提供“融合、开放、联动、弹性”的分布式算力资源，帮助用户业务下沉至运营商侧边缘，有效降低计算时延和成本。","link1":"https://ens.console.aliyun.com/?spm=5176.14468259.nav-right.159.21017341mrNdLP","btn1":"产品控制台","link2":"https://help.aliyun.com/document_detail/63848.html?spm=5176.cnens.0.0.184c42fbEOCZiM","btn2":"产品价格","btn3":"产品文档","link3":"https://help.aliyun.com/document_detail/63837.html?spm=5176.cnens.0.0.184c42fbEOCZiM","infoGroup":[{"infoName":"产品入门","infoContent":{"firstContentLink":"https://help.aliyun.com/document_detail/63855.html?spm=5176.cnens.0.0.184c42fbEOCZiM","firstContentName":"产品快速入门","lastContentName":"常见问题","lastContentLink":"https://help.aliyun.com/knowledge_detail/64663.html?spm=5176.cnens.0.0.184c42fbEOCZiM"}},{"infoName":"最新动态","infoContent":{"firstContentLink":"https://help.aliyun.com/document_detail/163248.html?spm=a2c4g.11186623.6.542.4cbf545eQNvlde","firstContentName":"产品最新动态","lastContentLink":"","lastContentName":""}}]}],"card":[],"search":[],"infoCard":[],"title":{"mainTitle":"mPaaS","subtitle":"源自于支付宝小程序框架，亿级线上业务体量的锤炼，安全性媲美支付宝原生能力。不仅面向自有 App 投放小程序，更可快速构建打包，覆盖支付宝、淘宝、钉钉等应用。","linkUrl":"https://www.aliyun.com/product/mobilepaas/mpaas-miniprogram","btnText":"查看详情"},"visual":{"topbg":"https://img.alicdn.com/tfs/TB1bQuBIYH1gK0jSZFwXXc7aXXa-3840-740.gif","icon":"","textColor":"dark"},"dataList":[{"summary":"啦啦啦","author":"wuwu","linksUrl":"#"}],"sceneCard":[],"txt":[]}}