API tools faq
paste
Advertisement
Guest User

Postgres Configuration

a guest
Jun 26th, 2013
467
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.37 KB | None | 0 0
raw download clone embed print report
  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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!