pgbench测试PG参数

最新推荐文章于 2024-06-30 19:45:19 发布

hadiniit

最新推荐文章于 2024-06-30 19:45:19 发布

阅读量1.6k

点赞数

分类专栏：测试

本文链接：https://blog.csdn.net/HADINIIT/article/details/88223915

版权

测试环境

流复制环境下，1主1备，加上1台测试机

测试机器

-测试机：10.37.64.52
-MASTER：10.37.64.53
-standby：10.37.64.54

3台机器的OS配置相同：
操作系统 RHEL 6.3 (64 Bit)，配置8C/16G/500G

postgresql当前参数配置

listen_addresses = '*'
port = 5432
max_connections = 1024
shared_buffers = 4GB
effective_cache_size = 12GB
work_mem = 4MB
maintenance_work_mem = 1GB
min_wal_size = 4GB
max_wal_size = 16GB
checkpoint_completion_target = 0.9
wal_buffers = 16MB
default_statistics_target = 100
checkpoint_timeout = 30min
wal_level = replica
wal_compression = on
wal_log_hints = on
synchronous_commit = remote_write
max_wal_senders=5
wal_keep_segments = 1000
hot_standby = on
wal_sender_timeout = 5000
wal_receiver_status_interval = 2
max_standby_streaming_delay = -1
max_standb