本篇内容主要讲解“怎么使用PostgreSQL的配置参数checkpoint_flush_after”，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习“怎么使用PostgreSQL的配置参数checkpoint_flush_after”吧!

在CentOS 7.x下使用sysbench测试,尝试0/256kB/2MB,只有可以忽略不计的细微区别.

-------------------------------------checkpoint_flush_after=2MB-------------------------------------SQLstatistics:queriesperformed:read:107367write:111268other:16840total:235475transactions:8419(84.16persec.)queries:235475(2353.96persec.)ignorederrors:43(0.43persec.)reconnects:0(0.00persec.)Throughput:events/s(eps):84.1616timeelapsed:100.0337stotalnumberofevents:8419Latency(ms):min:2.56avg:23.76max:311.6695thpercentile:62.19sum:200002.13Threadsfairness:events(avg/stddev):4209.5000/48.50executiontime(avg/stddev):100.0011/0.00-------------------------------------checkpoint_flush_after=256kB-------------------------------------SQLstatistics:queriesperformed:read:110021write:114168other:17072total:241261transactions:8535(85.31persec.)queries:241261(2411.50persec.)ignorederrors:29(0.29persec.)reconnects:0(0.00persec.)Throughput:events/s(eps):85.3106timeelapsed:100.0462stotalnumberofevents:8535Latency(ms):min:2.62avg:23.43max:260.3795thpercentile:61.08sum:200017.57Threadsfairness:events(avg/stddev):4267.5000/37.50executiontime(avg/stddev):100.0088/0.02-------------------------------------checkpoint_flush_after=0-------------------------------------SQLstatistics:queriesperformed:read:111431write:115279other:17380total:244090transactions:8689(86.86persec.)queries:244090(2440.19persec.)ignorederrors:42(0.42persec.)reconnects:0(0.00persec.)Throughput:events/s(eps):86.8646timeelapsed:100.0293stotalnumberofevents:8689Latency(ms):min:2.60avg:23.02max:213.3995thpercentile:59.99sum:199980.96Threadsfairness:events(avg/stddev):4344.5000/16.50executiontime(avg/stddev):99.9905/0.00

到此，相信大家对“怎么使用PostgreSQL的配置参数checkpoint_flush_after”有了更深的了解，不妨来实际操作一番吧！这里是亿速云网站，更多相关内容可以进入相关频道进行查询，关注我们，继续学习！