Skip to content

Instantly share code, notes, and snippets.

@skehlet

skehlet/gist:08aeed3d06f1c35bc780

Created March 17, 2016 18:58
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/08aeed3d06f1c35bc780 to your computer and use it in GitHub Desktop.
Save skehlet/08aeed3d06f1c35bc780 to your computer and use it in GitHub Desktop.
Download ZIP
my custom postgres settings
Raw
gistfile1.txt
postgres=# SELECT version();
version
---------------------------------------------------------------------------------------------------------------
PostgreSQL 9.4.5 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-44), 64-bit
(1 row)
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_freeze_max_age | 500000000 | configuration file
autovacuum_naptime | 1min | configuration file
autovacuum_vacuum_cost_delay | 10ms | configuration file
autovacuum_vacuum_cost_limit | 2000 | configuration file
autovacuum_vacuum_scale_factor | 0.1 | configuration file
autovacuum_vacuum_threshold | 50 | configuration file
checkpoint_completion_target | 0.9 | configuration file
checkpoint_segments | 32 | configuration file
client_encoding | UTF8 | client
effective_cache_size | 4GB | configuration file
hot_standby | 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 | 400 | 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
shared_buffers | 4GB | 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_level | hot_standby | configuration file
work_mem | 10MB | configuration file
(50 rows)
postgres=#
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment