AntDB 集中式安装部署 / 高可用集群模式部署3

数据库参数配置

数据库初始化前，可以通过修改自定义参数配置文件 setup/common/postgresql.conf.template 来设置参数配置。

在 antdb-t-ee-release-7.2.generic.* 下编辑 setup/common/postgresql.conf.template，如下所示：

# 下述参数为默认参数配置，可以自定义修改
listen_addresses='*'
superuser_reserved_connections=13
tcp_keepalives_idle=60
tcp_keepalives_interval=5
tcp_keepalives_count=10
work_mem=16MB
min_wal_size=2GB
maintenance_work_mem=1GB
max_stack_depth=7000
wal_sync_method=open_datasync
wal_compression=on
wal_log_hints=on
checkpoint_timeout=15min
checkpoint_completion_target=0.9
archive_mode=on
archive_command='/bin/date'
log_destination='csvlog'
logging_collector=on
log_directory='pg_log'
log_rotation_size=100MB
log_min_messages=error
track_activity_query_size=2048
autovacuum_max_workers=5
autovacuum_vacuum_threshold=500
autovacuum_analyze_threshold=500
idle_in_transaction_session_timeout=3600s
max_locks_per_transaction=256
#log_statement=ddl
#port=6655
#max_connections=100
#max_prepared_transactions=0
#max_worker_processes=108
#shared_buffers=128MB
#effective_cache_size=4GB
#max_wal_size=1GB
#random_page_cost=4.0

# 还可以自己增加相应的参数配置
port=5555        
max_connections=1000