怎么使用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”有了更深的了解，不妨来实际操作一番吧！这里是亿速云网站，更多相关内容可以进入相关频道进行查询，关注我们，继续学习！