Guest User

Postgres Configuration

a guest
Jun 26th, 2013
353
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. allow_system_table_mods off
  2. archive_command (disabled)
  3. archive_mode off
  4. archive_timeout 0
  5. array_nulls on
  6. authentication_timeout 1min
  7. autovacuum on
  8. autovacuum_analyze_scale_factor 0.1
  9. autovacuum_analyze_threshold 50
  10. autovacuum_freeze_max_age 200000000
  11. autovacuum_max_workers 3
  12. autovacuum_naptime 1min
  13. autovacuum_vacuum_cost_delay 20ms
  14. autovacuum_vacuum_cost_limit -1
  15. autovacuum_vacuum_scale_factor 0.2
  16. autovacuum_vacuum_threshold 50
  17. backslash_quote safe_encoding
  18. bgwriter_delay 200ms
  19. bgwriter_lru_maxpages 100
  20. bgwriter_lru_multiplier 2
  21. block_size 8192
  22. bonjour off
  23. bonjour_name
  24. bytea_output hex
  25. check_function_bodies on
  26. checkpoint_completion_target 0.7
  27. checkpoint_segments 8
  28. checkpoint_timeout 5min
  29. checkpoint_warning 30s
  30. client_encoding UTF8
  31. client_min_messages notice
  32. commit_delay 0
  33. commit_siblings 5
  34. config_file /var/lib/pgsql/9.2/data/postgresql.conf
  35. constraint_exclusion partition
  36. cpu_index_tuple_cost 0.001
  37. cpu_operator_cost 0.0005
  38. cpu_tuple_cost 0.003
  39. cursor_tuple_fraction 0.1
  40. data_directory /var/lib/pgsql/9.2/data
  41. DateStyle ISO, MDY
  42. db_user_namespace off
  43. deadlock_timeout 1s
  44. debug_assertions off
  45. debug_pretty_print on
  46. debug_print_parse off
  47. debug_print_plan off
  48. debug_print_rewritten off
  49. default_statistics_target 100
  50. default_tablespace
  51. default_text_search_config pg_catalog.english
  52. default_transaction_deferrable off
  53. default_transaction_isolation read committed
  54. default_transaction_read_only off
  55. default_with_oids off
  56. dynamic_library_path $libdir
  57. effective_cache_size 32GB
  58. effective_io_concurrency 1
  59. enable_bitmapscan on
  60. enable_hashagg on
  61. enable_hashjoin on
  62. enable_indexonlyscan on
  63. enable_indexscan on
  64. enable_material on
  65. enable_mergejoin on
  66. enable_nestloop on
  67. enable_seqscan on
  68. enable_sort on
  69. enable_tidscan on
  70. escape_string_warning on
  71. event_source PostgreSQL
  72. exit_on_error off
  73. external_pid_file
  74. extra_float_digits 0
  75. from_collapse_limit 4
  76. fsync on
  77. full_page_writes on
  78. geqo on
  79. geqo_effort 5
  80. geqo_generations 0
  81. geqo_pool_size 0
  82. geqo_seed 0
  83. geqo_selection_bias 2
  84. geqo_threshold 12
  85. gin_fuzzy_search_limit 0
  86. hba_file /var/lib/pgsql/9.2/data/pg_hba.conf
  87. hot_standby off
  88. hot_standby_feedback off
  89. ident_file /var/lib/pgsql/9.2/data/pg_ident.conf
  90. ignore_system_indexes off
  91. integer_datetimes on
  92. IntervalStyle postgres
  93. join_collapse_limit 4
  94. krb_caseins_users off
  95. krb_server_keyfile FILE:/etc/sysconfig/pgsql/krb5.keytab
  96. krb_srvname postgres
  97. lc_collate en_US.UTF-8
  98. lc_ctype en_US.UTF-8
  99. lc_messages en_US.UTF-8
  100. lc_monetary en_US.UTF-8
  101. lc_numeric en_US.UTF-8
  102. lc_time en_US.UTF-8
  103. listen_addresses *
  104. lo_compat_privileges off
  105. local_preload_libraries
  106. log_autovacuum_min_duration -1
  107. log_checkpoints off
  108. log_connections off
  109. log_destination stderr
  110. log_directory pg_log
  111. log_disconnections off
  112. log_duration off
  113. log_error_verbosity default
  114. log_executor_stats off
  115. log_file_mode 0600
  116. log_filename postgresql-%a.log
  117. log_hostname off
  118. log_line_prefix
  119. log_lock_waits off
  120. log_min_duration_statement -1
  121. log_min_error_statement error
  122. log_min_messages warning
  123. log_parser_stats off
  124. log_planner_stats off
  125. log_rotation_age 1d
  126. log_rotation_size 0
  127. log_statement none
  128. log_statement_stats off
  129. log_temp_files -1
  130. log_timezone US/Eastern
  131. log_truncate_on_rotation on
  132. logging_collector on
  133. maintenance_work_mem 1GB
  134. max_connections 200
  135. max_files_per_process 1000
  136. max_function_args 100
  137. max_identifier_length 63
  138. max_index_keys 32
  139. max_locks_per_transaction 64
  140. max_pred_locks_per_transaction 64
  141. max_prepared_transactions 0
  142. max_stack_depth 2MB
  143. max_standby_archive_delay 30s
  144. max_standby_streaming_delay 30s
  145. max_wal_senders 0
  146. password_encryption on
  147. port 5432
  148. post_auth_delay 0
  149. pre_auth_delay 0
  150. quote_all_identifiers off
  151. random_page_cost 4
  152. replication_timeout 1min
  153. restart_after_crash on
  154. search_path "$user",public
  155. segment_size 1GB
  156. seq_page_cost 1
  157. server_encoding UTF8
  158. server_version 9.2.4
  159. server_version_num 90204
  160. session_replication_role origin
  161. shared_buffers 24GB
  162. shared_preload_libraries
  163. sql_inheritance on
  164. ssl off
  165. ssl_ca_file
  166. ssl_cert_file server.crt
  167. ssl_ciphers ALL:!ADH:!LOW:!EXP:!MD5:@STRENGTH
  168. ssl_crl_file
  169. ssl_key_file server.key
  170. ssl_renegotiation_limit 512MB
  171. standard_conforming_strings on
  172. statement_timeout 0
  173. stats_temp_directory pg_stat_tmp
  174. superuser_reserved_connections 3
  175. synchronize_seqscans on
  176. synchronous_commit on
  177. synchronous_standby_names
  178. syslog_facility local0
  179. syslog_ident postgres
  180. tcp_keepalives_count 9
  181. tcp_keepalives_idle 7200
  182. tcp_keepalives_interval 75
  183. temp_buffers 8MB
  184. temp_file_limit -1
  185. temp_tablespaces
  186. TimeZone US/Eastern
  187. timezone_abbreviations Default
  188. trace_notify off
  189. trace_recovery_messages log
  190. trace_sort off
  191. track_activities on
  192. track_activity_query_size 1024
  193. track_counts on
  194. track_functions none
  195. track_io_timing off
  196. transaction_deferrable off
  197. transaction_isolation read committed
  198. transaction_read_only off
  199. transform_null_equals off
  200. unix_socket_directory
  201. unix_socket_group
  202. unix_socket_permissions 0777
  203. update_process_title on
  204. vacuum_cost_delay 0
  205. vacuum_cost_limit 200
  206. vacuum_cost_page_dirty 20
  207. vacuum_cost_page_hit 1
  208. vacuum_cost_page_miss 10
  209. vacuum_defer_cleanup_age 0
  210. vacuum_freeze_min_age 50000000
  211. vacuum_freeze_table_age 150000000
  212. wal_block_size 8192
  213. wal_buffers 4MB
  214. wal_keep_segments 0
  215. wal_level minimal
  216. wal_receiver_status_interval 10s
  217. wal_segment_size 16MB
  218. wal_sync_method fdatasync
  219. wal_writer_delay 200ms
  220. work_mem 96MB
  221. xmlbinary base64
  222. xmloption content
  223. zero_damaged_pages off
RAW Paste Data