digoal / blog

Opensource,Database,AI,Business,Minds. git clone --depth 1 https://github.com/digoal/blog
https://github.com/digoal/blog/blob/master/README.md
GNU General Public License v2.0
8.09k stars 1.89k forks source link

PG10.15进行3小时压测后,top查看内存无空闲内存问题 #91

Closed java30kcoding closed 3 years ago

java30kcoding commented 3 years ago

机器配置

PG配置

参考的:https://github.com/digoal/blog/blob/master/201611/20161121_01.md

进行了从512到32G的配置缩减

2kw数据复杂数据压测

参考:https://github.com/digoal/blog/blob/master/201203/20120313_01.md

./pgbench -M prepared -r -c 8 -f login.sql -j 8 -n -T 60
# 21000TPS

压测3小时命令

压了230分钟左右停止了压测命令

./pgbench -M prepared -r -c 8 -f login.sql -j 8 -n -T 1800000

压测一天过后的内存状态

KiB Mem : 32780852 total, 267268 free, 356752 used, 32156832 buff/cache KiB Swap: 4194300 total, 4194300 free, 0 used. 23003220 avail Mem

求问德哥,这个状态正常嘛?感激不尽~

java30kcoding commented 3 years ago

压测时服务器状态

digoal commented 3 years ago

正常, 大部分都是buffer cache