怎么使用PostgreSQL的配置参数checkpoint_flush_after

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

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

------------------------------------- checkpoint_flush_after = 2MB ------------------------------------- SQL statistics:     queries performed:         read:                            107367         write:                           111268         other:                           16840         total:                           235475     transactions:                        8419   (84.16 per sec.)     queries:                             235475 (2353.96 per sec.)     ignored errors:                      43     (0.43 per sec.)     reconnects:                          0      (0.00 per sec.) Throughput:     events/s (eps):                      84.1616     time elapsed:                        100.0337s     total number of events:              8419 Latency (ms):          min:                                    2.56          avg:                                   23.76          max:                                  311.66          95th percentile:                       62.19          sum:                               200002.13 Threads fairness:     events (avg/stddev):           4209.5000/48.50     execution time (avg/stddev):   100.0011/0.00 ------------------------------------- checkpoint_flush_after = 256kB ------------------------------------- SQL statistics:     queries performed:         read:                            110021         write:                           114168         other:                           17072         total:                           241261     transactions:                        8535   (85.31 per sec.)     queries:                             241261 (2411.50 per sec.)     ignored errors:                      29     (0.29 per sec.)     reconnects:                          0      (0.00 per sec.) Throughput:     events/s (eps):                      85.3106     time elapsed:                        100.0462s     total number of events:              8535 Latency (ms):          min:                                    2.62          avg:                                   23.43          max:                                  260.37          95th percentile:                       61.08          sum:                               200017.57 Threads fairness:     events (avg/stddev):           4267.5000/37.50     execution time (avg/stddev):   100.0088/0.02 ------------------------------------- checkpoint_flush_after = 0 ------------------------------------- SQL statistics:     queries performed:         read:                            111431         write:                           115279         other:                           17380         total:                           244090     transactions:                        8689   (86.86 per sec.)     queries:                             244090 (2440.19 per sec.)     ignored errors:                      42     (0.42 per sec.)     reconnects:                          0      (0.00 per sec.) Throughput:     events/s (eps):                      86.8646     time elapsed:                        100.0293s     total number of events:              8689 Latency (ms):          min:                                    2.60          avg:                                   23.02          max:                                  213.39          95th percentile:                       59.99          sum:                               199980.96 Threads fairness:     events (avg/stddev):           4344.5000/16.50     execution time (avg/stddev):   99.9905/0.00

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