本篇內(nèi)容主要講解“怎么使用PostgreSQL的配置參數(shù)checkpoint_flush_after”，感興趣的朋友不妨來看看。本文介紹的方法操作簡單快捷，實用性強。下面就讓小編來帶大家學習“怎么使用PostgreSQL的配置參數(shù)checkpoint_flush_after”吧!

創(chuàng)新互聯(lián)公司是網(wǎng)站建設(shè)技術(shù)企業(yè)，為成都企業(yè)提供專業(yè)的成都做網(wǎng)站、成都網(wǎng)站制作，網(wǎng)站設(shè)計，網(wǎng)站制作，網(wǎng)站改版等技術(shù)服務。擁有10年豐富建站經(jīng)驗和眾多成功案例，為您定制適合企業(yè)的網(wǎng)站。10年品質(zhì)，值得信賴！

在CentOS 7.x下使用sysbench測試,嘗試0/256kB/2MB,只有可以忽略不計的細微區(qū)別.

-------------------------------------
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的配置參數(shù)checkpoint_flush_after”有了更深的了解，不妨來實際操作一番吧！這里是創(chuàng)新互聯(lián)網(wǎng)站，更多相關(guān)內(nèi)容可以進入相關(guān)頻道進行查詢，關(guān)注我們，繼續(xù)學習！