Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [gray@rxtx-249 tmp]$ sudo cat /var/lib/pgsql/data/postgresql.conf|grep -v -P '^\s*#|^\s*$'| perl -pne 's/\s*#.*$//'
- listen_addresses = '*'
- max_connections = 300
- shared_buffers = 2GB
- work_mem = 64MB
- maintenance_work_mem = 256MB
- shared_preload_libraries = 'auto_explain,pg_stat_statements'
- bgwriter_lru_maxpages = 700
- synchronous_commit = off
- wal_buffers = 8MB
- checkpoint_segments = 50
- checkpoint_timeout = 10min
- checkpoint_completion_target = 0.8
- effective_cache_size = 10GB
- constraint_exclusion = on
- log_destination = 'syslog'
- silent_mode = on
- log_min_error_statement = warning
- log_min_duration_statement = 2000ms
- log_checkpoints = on
- log_statement = 'none'
- track_activity_query_size = 16384
- log_autovacuum_min_duration = 0
- autovacuum_naptime = 10min
- autovacuum_vacuum_threshold = 500
- autovacuum_analyze_threshold = 250
- autovacuum_vacuum_scale_factor = 0.05
- autovacuum_analyze_scale_factor = 0.03
- statement_timeout = 35000
- datestyle = 'iso, dmy'
- timezone = 'Europe/Moscow'
- lc_messages = 'en_US.UTF-8'
- lc_monetary = 'en_US.UTF-8'
- lc_numeric = 'en_US.UTF-8'
- lc_time = 'en_US.UTF-8'
- default_text_search_config = 'pg_catalog.english'
- escape_string_warning = off
- custom_variable_classes = 'auto_explain,pg_stat_statements'
- auto_explain.log_min_duration = '3s'
- pg_stat_statements.max = 10000
- pg_stat_statements.track = all
Add Comment
Please, Sign In to add comment