内存sharedbuffers

shared_buffers=16GB#IF use hugepage:规格内存*(1/4)ELSE:min(32GB,规格内存*(1/4))

shared_buffers=16GB#IF use hugepage:规格内存(1/4)ELSE:min(32GB,规格内存(1/4))这个如果是512的内存，还要按这个标准设置吗，shared_buffers=min(32GB,512*(1/4))=32G 还是直接使用shared_buffers=512*1/4 用 128G，大页使用shared_...

问个问题，服务器内存是192G，现在经常内存爆满，...shared_buffers是64G。work_mem是4G

问个问题，服务器内存是192G，现在经常内存爆满，Cpu缺不高。shared_buffers是64G。work_mem是4G。连接数也不高。是什么原因造成这么高的内存消耗啊

磁盘IO性能一般，我系统内存是32GB，每秒并发量200不到，我的PG的shared_buffers的值...

喜爱PostgresSQL的同学扫码进群

内存buffersshared相关内容

.32g内存sharedbuffers

内存更多"buffers"相关

.32g内存buffers

内存sharedbuffers相关内容

.32g内存shared

您可能感兴趣

.升级内存 .内核内存 .虚拟机内存 .linux内存 .内存操作 .检测内存 .代码内存 .c++对象内存

{"optioninfo":{"dynamic":"ture","static":"true"},"simplifiedDisplay":"newEdition","newCard":[{"ifIcon":"img","link":"https://img.alicdn.com/tfs/TB1XY8hGYr1gK0jSZFDXXb9yVXa-1740-328.png","icon":"云原生内存数据库Tair","iconImg":"https://img.alicdn.com/imgextra/i2/O1CN01pd8Nn51vQzhljWKjr_!!6000000006168-2-tps-200-200.png","contentLink":"https://www.aliyun.com/product/apsaradb/kvstore/tair","title":"云原生内存数据库Tair","des":"云原生内存数据库Tair是阿里云自研数据库，充分兼容Redis的同时提供全球多活、任意时间点恢复和透明加密等企业级能力。支持多种存储介质，提供内存型、持久内存型、图引擎等产品形态，满足不同的业务场景和性价比需求。","link1":"https://www.aliyun.com/product/apsaradb/kvstore/tair","btn1":"了解详情","link2":"https://kvstorenext.console.aliyun.com/Tair","btn2":"管理控制台","btn3":"在线咨询","link3":"https://www.aliyun.com/core/online-consult?from=pHIqQNCdBL","infoGroup":[{"infoName":"最新活动","infoContent":{"firstContentName":"Tair内存型新用户享3折","firstContentLink":"https://common-buy.aliyun.com/?commodityCode=kvstore_pretair_public_cn&request=%7B%22ord_time%22:%221:Year%22,%22order_num%22:1,%22kvstore_series_type%22:%22tair_rdb%22,%22region%22:%22cn-hangzhou%22,%22kvstore_zonetype%22:%22singlezone%22,%22kvstore_iz%22:%22cn-hangzhou-g%22,%22kvstore_web_type%22:%221%22,%22instance_type%22:%22standard_type%22,%22kvstore_engineversion_type%22:%22rdb5.0%22,%22kvstore_architecture_type%22:%22non_cluster%22,%22shard_type%22:%22share%22,%22rwsplit_switch%22:%22false%22,%22shard_class%22:%22tair.rdb.1g%22,%22replica_quantity%22:%222%22,%22ro_quantity%22:%220%22,%22shard_quantity%22:1,%22kvstore_password%22:%22later%22%7D®ionId=cn-hangzhou","lastContentLink":"https://www.aliyun.com/database/dbfirstbuy","lastContentName":"数据库精选特惠"}},{"infoName":"产品入门","infoContent":{"firstContentName":"帮助文档","lastContentName":"快速入门","firstContentLink":"https://help.aliyun.com/document_detail/441340.html","lastContentLink":"https://help.aliyun.com/document_detail/443862.html"}},{"infoName":"最佳实践","infoContent":{"firstContentLink":"https://help.aliyun.com/document_detail/443681.html","firstContentName":"基于Tair的高效限流器","lastContentName":"数据库客户案例合集","lastContentLink":"https://www.aliyun.com/database/case"}},{"infoName":"产品推荐","infoContent":{"firstContentLink":"https://www.aliyun.com/product/kvstore","firstContentName":"云数据库 Redis 版","lastContentLink":"https://www.aliyun.com/product/apsaradb/lindorm","lastContentName":"云数据库 Lindorm"}}]}],"card":[],"search":[],"infoCard":[{"bannerUrl":"https://img.alicdn.com/tfs/TB1XY8hGYr1gK0jSZFDXXb9yVXa-1740-328.png","bannerTitle":"云原生内存数据库Tair","bannerContent":"","liveButtonName":"查看详情","liveButtonLink":"https://help.aliyun.com/document_detail/441340.html","contentTitle":"","homePageLink":"https://kvstorenext.console.aliyun.com/Tair","homePageName":"Tair控制台","linkGroup":[{"linkContent":"发布包大小极致优化，节省流量和存储。"},{"linkContent":"服务迭代不再受发版限制，快速发布，快速迭代。"},{"linkContent":"业务开发效率更加优秀，一次开发，多端运行。"}]}],"title":{"mainTitle":"云原生内存数据库Tair","subtitle":"","linkUrl":"https://help.aliyun.com/document_detail/441340.html","btnText":"产品文档"},"visual":{"topbg":"https://img.alicdn.com/imgextra/i2/O1CN01c5dDHA1r0eSieV7LB_!!6000000005569-1-tps-3840-740.gif","icon":"","textColor":"dark"},"dataList":[],"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":"云原生内存数据库Tair","iconImg":"https://img.alicdn.com/imgextra/i2/O1CN01pd8Nn51vQzhljWKjr_!!6000000006168-2-tps-200-200.png","contentLink":"https://www.aliyun.com/product/apsaradb/kvstore/tair","title":"云原生内存数据库Tair","des":"云原生内存数据库Tair是阿里云自研数据库，充分兼容Redis的同时提供全球多活、任意时间点恢复和透明加密等企业级能力。支持多种存储介质，提供内存型、持久内存型、图引擎等产品形态，满足不同的业务场景和性价比需求。","link1":"https://www.aliyun.com/product/apsaradb/kvstore/tair","btn1":"了解详情","link2":"https://kvstorenext.console.aliyun.com/Tair","btn2":"管理控制台","btn3":"在线咨询","link3":"https://www.aliyun.com/core/online-consult?from=pHIqQNCdBL","infoGroup":[{"infoName":"最新活动","infoContent":{"firstContentName":"Tair内存型新用户享3折","firstContentLink":"https://common-buy.aliyun.com/?commodityCode=kvstore_pretair_public_cn&request=%7B%22ord_time%22:%221:Year%22,%22order_num%22:1,%22kvstore_series_type%22:%22tair_rdb%22,%22region%22:%22cn-hangzhou%22,%22kvstore_zonetype%22:%22singlezone%22,%22kvstore_iz%22:%22cn-hangzhou-g%22,%22kvstore_web_type%22:%221%22,%22instance_type%22:%22standard_type%22,%22kvstore_engineversion_type%22:%22rdb5.0%22,%22kvstore_architecture_type%22:%22non_cluster%22,%22shard_type%22:%22share%22,%22rwsplit_switch%22:%22false%22,%22shard_class%22:%22tair.rdb.1g%22,%22replica_quantity%22:%222%22,%22ro_quantity%22:%220%22,%22shard_quantity%22:1,%22kvstore_password%22:%22later%22%7D®ionId=cn-hangzhou","lastContentLink":"https://www.aliyun.com/database/dbfirstbuy","lastContentName":"数据库精选特惠"}},{"infoName":"产品入门","infoContent":{"firstContentName":"帮助文档","lastContentName":"快速入门","firstContentLink":"https://help.aliyun.com/document_detail/441340.html","lastContentLink":"https://help.aliyun.com/document_detail/443862.html"}},{"infoName":"最佳实践","infoContent":{"firstContentLink":"https://help.aliyun.com/document_detail/443681.html","firstContentName":"基于Tair的高效限流器","lastContentName":"数据库客户案例合集","lastContentLink":"https://www.aliyun.com/database/case"}},{"infoName":"产品推荐","infoContent":{"firstContentLink":"https://www.aliyun.com/product/kvstore","firstContentName":"云数据库 Redis 版","lastContentLink":"https://www.aliyun.com/product/apsaradb/lindorm","lastContentName":"云数据库 Lindorm"}}]}],"card":[],"search":[],"infoCard":[{"bannerUrl":"https://img.alicdn.com/tfs/TB1XY8hGYr1gK0jSZFDXXb9yVXa-1740-328.png","bannerTitle":"云原生内存数据库Tair","bannerContent":"","liveButtonName":"查看详情","liveButtonLink":"https://help.aliyun.com/document_detail/441340.html","contentTitle":"","homePageLink":"https://kvstorenext.console.aliyun.com/Tair","homePageName":"Tair控制台","linkGroup":[{"linkContent":"发布包大小极致优化，节省流量和存储。"},{"linkContent":"服务迭代不再受发版限制，快速发布，快速迭代。"},{"linkContent":"业务开发效率更加优秀，一次开发，多端运行。"}]}],"title":{"mainTitle":"云原生内存数据库Tair","subtitle":"","linkUrl":"https://help.aliyun.com/document_detail/441340.html","btnText":"产品文档"},"visual":{"topbg":"https://img.alicdn.com/imgextra/i2/O1CN01c5dDHA1r0eSieV7LB_!!6000000005569-1-tps-3840-740.gif","icon":"","textColor":"dark"},"dataList":[],"sceneCard":[],"txt":[]}}

云原生内存数据库Tair

云原生内存数据库Tair是阿里云自研数据库，充分兼容Redis的同时提供全球多活、任意时间点恢复和透明加密等企业级能力。支持多种存储介质，提供内存型、持久内存型、图引擎等产品形态，满足不同的业务场景和性价比需求。

了解详情

管理控制台

在线咨询