1、shared_buffers
调整为内存的1/4,我这64GB这里设置为:
shared_buffers = 16GB
2、wal_buffers
wal_buffers = 50MB
50MB 【待测试】
https://blog.csdn.net/shipeng1022/article/details/108650124
3、effective_cache_size
effective_cache_size = RAM * 0.7 内存的百分之七十
effective_cache_size = 40GB
4、work_mem
设置为64MB
work_mem = 64MB
http://www.manongjc.com/article/61627.html
5、fsync
设为false,可能会丢失部分数据,但会提升性能
下面是详细的教程:
https://www.cnblogs.com/VicLiu/p/11854730.html