Skip to content

Instantly share code, notes, and snippets.

@skehlet

skehlet/gist:fd4945f9c9ce6ed075f1

Created August 28, 2015 16:53
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save skehlet/fd4945f9c9ce6ed075f1 to your computer and use it in GitHub Desktop.
Save skehlet/fd4945f9c9ce6ed075f1 to your computer and use it in GitHub Desktop.
Download ZIP
my non-default postgres config
Raw
gistfile1.txt
psql (9.4.4)
Type "help" for help.
postgres=#
postgres=# SELECT name, current_setting(name), source
postgres-# FROM pg_settings
postgres-# WHERE source NOT IN ('default', 'override');
name | current_setting | source
---------------------------------+----------------------------------+--------------------
application_name | psql | client
archive_command | /opt/pgsql/bin/wal_shipper.rb %p | configuration file
archive_mode | on | configuration file
autovacuum | on | configuration file
autovacuum_analyze_scale_factor | 0.1 | configuration file
autovacuum_analyze_threshold | 50 | configuration file
autovacuum_naptime | 1min | configuration file
autovacuum_vacuum_cost_delay | 20ms | configuration file
autovacuum_vacuum_cost_limit | 200 | configuration file
autovacuum_vacuum_scale_factor | 0.2 | configuration file
autovacuum_vacuum_threshold | 50 | configuration file
checkpoint_completion_target | 0.9 | configuration file
checkpoint_segments | 128 | configuration file
client_encoding | UTF8 | client
effective_cache_size | 16GB | configuration file
hot_standby | on | configuration file
hot_standby_feedback | on | configuration file
lc_messages | C | configuration file
lc_monetary | en_US.UTF-8 | configuration file
lc_numeric | en_US.UTF-8 | configuration file
lc_time | en_US.UTF-8 | configuration file
listen_addresses | * | configuration file
log_autovacuum_min_duration | 0 | configuration file
log_checkpoints | on | configuration file
log_connections | on | configuration file
log_disconnections | on | configuration file
log_line_prefix | %t [%p]: [%l-1] | configuration file
log_lock_waits | on | configuration file
log_min_duration_statement | 1s | configuration file
log_temp_files | 0 | configuration file
log_timezone | US/Eastern | configuration file
maintenance_work_mem | 512MB | configuration file
max_connections | 300 | configuration file
max_stack_depth | 8MB | configuration file
max_standby_archive_delay | 30min | configuration file
max_standby_streaming_delay | 30min | configuration file
max_wal_senders | 10 | configuration file
port | 5432 | configuration file
random_page_cost | 1.3 | configuration file
shared_buffers | 8GB | configuration file
shared_preload_libraries | pg_stat_statements,repmgr_funcs | configuration file
tcp_keepalives_count | 9 | configuration file
tcp_keepalives_idle | 1500 | configuration file
tcp_keepalives_interval | 75 | configuration file
TimeZone | US/Eastern | configuration file
track_activity_query_size | 4096 | configuration file
vacuum_cost_delay | 20ms | configuration file
vacuum_cost_limit | 200 | configuration file
wal_buffers | 16MB | configuration file
wal_keep_segments | 5000 | configuration file
wal_level | hot_standby | configuration file
work_mem | 10MB | configuration file
(52 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment