怎么使用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:              8419Latency (ms):         min:                                    2.56         avg:                                   23.76         max:                                  311.66         95th percentile:                       62.19         sum:                               200002.13Threads 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:              8535Latency (ms):         min:                                    2.62         avg:                                   23.43         max:                                  260.37         95th percentile:                       61.08         sum:                               200017.57Threads 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:              8689Latency (ms):         min:                                    2.60         avg:                                   23.02         max:                                  213.39         95th percentile:                       59.99         sum:                               199980.96Threads fairness:    events (avg/stddev):           4344.5000/16.50    execution time (avg/stddev):   99.9905/0.00

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