一个老外对postgresql.conf的重新组织
配置文件很长,不好管理,一般就是一些主要参数,我们重新组织一下## Connectingport = 5432listen_addresses = '*'max_connections = 100ssl = on## Memoryshared_buffers = 100MB ## Diskfsync = onsynchronous_commit = onfull_page_writes = oncheckpoint_segments = 3 ## PITRarchive_mode = onarchive_command = 'cp %p /usr/local/pgsql/arch/%f;scp %p 218.193.224.22:/usr/local/pgsql/arch_from_11/%f'archive_timeout = 0wal_level = hot_standbymax_wal_senders = 1 ## Plannereffective_cache_size = 128MBrandom_page_cost = 4.0 ## Logginglog_destination = 'stderr'logging_collector = onlog_filename = 'pg%Y-%m-%d_%H%M%S.log'silent_mode = onclient_min_messages = loglog_min_messages = loglog_truncate_on_rotation = offlog_rotation_age = 1dlog_rotation_size = 10MBlog_min_duration_statement = -1log_statement = 'none'log_line_prefix = '%t %u@%d %p' ## Autovacuumautovacuum = onautovacuum_vacuum_scale_factor= 0.2autovacuum_analyze_scale_factor = 0.1
还可以把一些替换参数集合起来,放在一个位置,如文件尾部,用于快速替换这些参数
老外举了一个了例子,在大流量访问的时候以下三个参数关闭,避免影响性能.
## Bulk loading only - leave 'on' for everyday use!autovacuum = offfsync = offfull_page_writes = off
遵循后置有效哦,同一参数设置以最后一次出现为准.
而且8.3以后新配置文件中删除了前一次的配置项后reload自动变默认,
以前版本删除了配置文件中某项设置,reload后保持前一设置不变
页:
[1]