gistfile1.sql

listen_addresses = '*'
port = 5432
max_connections = 300
shared_buffers = 2GB
work_mem = 10MB
maintenance_work_mem = 256MB
max_stack_depth = 8MB
wal_buffers = 16MB
checkpoint_segments = 32
checkpoint_completion_target = .9
effective_cache_size = 2GB
log_line_prefix = '%t [%p]: [%l-1] '
autovacuum = on
autovacuum_naptime = 1min
autovacuum_vacuum_threshold = 50
autovacuum_analyze_threshold = 50
autovacuum_vacuum_scale_factor = 0.2
autovacuum_analyze_scale_factor = 0.1
autovacuum_vacuum_cost_delay = 20ms
autovacuum_vacuum_cost_limit = 200
lc_messages = C
lc_monetary = 'en_US.UTF-8'
lc_numeric = 'en_US.UTF-8'
lc_time = 'en_US.UTF-8'
log_autovacuum_min_duration = 0
vacuum_cost_delay = 20ms
vacuum_cost_limit = 200
log_lock_waits = on
log_temp_files = 0
track_activity_query_size = 4096
shared_preload_libraries = 'pg_stat_statements,repmgr_funcs'
log_min_duration_statement = 1000
log_statement = 'all'
wal_level='hot_standby'
archive_mode=on
archive_command='/opt/pgsql/bin/wal_shipper.rb %p'
max_wal_senders=10
hot_standby=on
max_standby_streaming_delay=30min
max_standby_archive_delay=30min
tcp_keepalives_idle=0
tcp_keepalives_interval=0
tcp_keepalives_count=0
TimeZone='US/Pacific'
log_timezone='US/Pacific'