API tools faq
paste
Guest User

postgresql.conf pgsql-clu-02

a guest
Mar 28th, 2019
136
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 29.97 KB | None | 0 0
raw download clone embed print report
  1. # -----------------------------
  2. # PostgreSQL configuration file
  3. # -----------------------------
  4. #
  5. # This file consists of lines of the form:
  6. #
  7. # name = value
  8. #
  9. # (The "=" is optional.) Whitespace may be used. Comments are introduced with
  10. # "#" anywhere on a line. The complete list of parameter names and allowed
  11. # values can be found in the PostgreSQL documentation.
  12. #
  13. # The commented-out settings shown in this file represent the default values.
  14. # Re-commenting a setting is NOT sufficient to revert it to the default value;
  15. # you need to reload the server.
  16. #
  17. # This file is read on server startup and when the server receives a SIGHUP
  18. # signal. If you edit the file on a running system, you have to SIGHUP the
  19. # server for the changes to take effect, or use "pg_ctl reload". Some
  20. # parameters, which are marked below, require a server shutdown and restart to
  21. # take effect.
  22. #
  23. # Any parameter can also be given as a command-line option to the server, e.g.,
  24. # "postgres -c log_connections=on". Some parameters can be changed at run time
  25. # with the "SET" SQL command.
  26. #
  27. # Memory units: kB = kilobytes Time units: ms = milliseconds
  28. # MB = megabytes s = seconds
  29. # GB = gigabytes min = minutes
  30. # TB = terabytes h = hours
  31. # d = days
  32.  
  33.  
  34. #------------------------------------------------------------------------------
  35. # FILE LOCATIONS
  36. #------------------------------------------------------------------------------
  37.  
  38. # The default values of these variables are driven from the -D command-line
  39. # option or PGDATA environment variable, represented here as ConfigDir.
  40.  
  41. #data_directory = 'ConfigDir' # use data in another directory
  42. # (change requires restart)
  43. #hba_file = 'ConfigDir/pg_hba.conf' # host-based authentication file
  44. # (change requires restart)
  45. #ident_file = 'ConfigDir/pg_ident.conf' # ident configuration file
  46. # (change requires restart)
  47.  
  48. # If external_pid_file is not explicitly set, no extra PID file is written.
  49. #external_pid_file = '' # write an extra PID file
  50. # (change requires restart)
  51.  
  52.  
  53. #------------------------------------------------------------------------------
  54. # CONNECTIONS AND AUTHENTICATION
  55. #------------------------------------------------------------------------------
  56.  
  57. # - Connection Settings -
  58.  
  59. listen_addresses = '*' # what IP address(es) to listen on;
  60. # comma-separated list of addresses;
  61. # defaults to 'localhost'; use '*' for all
  62. # (change requires restart)
  63. #port = 5432 # (change requires restart)
  64. max_connections = 100 # (change requires restart)
  65. #superuser_reserved_connections = 3 # (change requires restart)
  66. #unix_socket_directories = '/tmp' # comma-separated list of directories
  67. # (change requires restart)
  68. #unix_socket_group = '' # (change requires restart)
  69. #unix_socket_permissions = 0777 # begin with 0 to use octal notation
  70. # (change requires restart)
  71. #bonjour = off # advertise server via Bonjour
  72. # (change requires restart)
  73. #bonjour_name = '' # defaults to the computer name
  74. # (change requires restart)
  75.  
  76. # - Security and Authentication -
  77.  
  78. #authentication_timeout = 1min # 1s-600s
  79. #ssl = off # (change requires restart)
  80. #ssl_ciphers = 'HIGH:MEDIUM:+3DES:!aNULL' # allowed SSL ciphers
  81. # (change requires restart)
  82. #ssl_prefer_server_ciphers = on # (change requires restart)
  83. #ssl_ecdh_curve = 'prime256v1' # (change requires restart)
  84. #ssl_cert_file = 'server.crt' # (change requires restart)
  85. #ssl_key_file = 'server.key' # (change requires restart)
  86. #ssl_ca_file = '' # (change requires restart)
  87. #ssl_crl_file = '' # (change requires restart)
  88. #password_encryption = on
  89. #db_user_namespace = off
  90. #row_security = on
  91.  
  92. # GSSAPI using Kerberos
  93. #krb_server_keyfile = ''
  94. #krb_caseins_users = off
  95.  
  96. # - TCP Keepalives -
  97. # see "man 7 tcp" for details
  98.  
  99. #tcp_keepalives_idle = 0 # TCP_KEEPIDLE, in seconds;
  100. # 0 selects the system default
  101. #tcp_keepalives_interval = 0 # TCP_KEEPINTVL, in seconds;
  102. # 0 selects the system default
  103. #tcp_keepalives_count = 0 # TCP_KEEPCNT;
  104. # 0 selects the system default
  105.  
  106.  
  107. #------------------------------------------------------------------------------
  108. # RESOURCE USAGE (except WAL)
  109. #------------------------------------------------------------------------------
  110.  
  111. # - Memory -
  112.  
  113. shared_buffers = 128MB # min 128kB
  114. # (change requires restart)
  115. #huge_pages = try # on, off, or try
  116. # (change requires restart)
  117. #temp_buffers = 8MB # min 800kB
  118. #max_prepared_transactions = 0 # zero disables the feature
  119. # (change requires restart)
  120. # Caution: it is not advisable to set max_prepared_transactions nonzero unless
  121. # you actively intend to use prepared transactions.
  122. #work_mem = 4MB # min 64kB
  123. #maintenance_work_mem = 64MB # min 1MB
  124. #replacement_sort_tuples = 150000 # limits use of replacement selection sort
  125. #autovacuum_work_mem = -1 # min 1MB, or -1 to use maintenance_work_mem
  126. #max_stack_depth = 2MB # min 100kB
  127. dynamic_shared_memory_type = posix # the default is the first option
  128. # supported by the operating system:
  129. # posix
  130. # sysv
  131. # windows
  132. # mmap
  133. # use none to disable dynamic shared memory
  134. # (change requires restart)
  135.  
  136. # - Disk -
  137.  
  138. #temp_file_limit = -1 # limits per-process temp file space
  139. # in kB, or -1 for no limit
  140.  
  141. # - Kernel Resource Usage -
  142.  
  143. #max_files_per_process = 1000 # min 25
  144. # (change requires restart)
  145. shared_preload_libraries = 'online_analyze, plantuner, repmgr' # (change requires restart)
  146.  
  147. # - Cost-Based Vacuum Delay -
  148.  
  149. #vacuum_cost_delay = 0 # 0-100 milliseconds
  150. #vacuum_cost_page_hit = 1 # 0-10000 credits
  151. #vacuum_cost_page_miss = 10 # 0-10000 credits
  152. #vacuum_cost_page_dirty = 20 # 0-10000 credits
  153. #vacuum_cost_limit = 200 # 1-10000 credits
  154.  
  155. # - Background Writer -
  156.  
  157. #bgwriter_delay = 200ms # 10-10000ms between rounds
  158. #bgwriter_lru_maxpages = 100 # 0-1000 max buffers written/round
  159. #bgwriter_lru_multiplier = 2.0 # 0-10.0 multiplier on buffers scanned/round
  160. #bgwriter_flush_after = 512kB # measured in pages, 0 disables
  161.  
  162. # - Asynchronous Behavior -
  163.  
  164. #effective_io_concurrency = 1 # 1-1000; 0 disables prefetching
  165. #max_worker_processes = 8 # (change requires restart)
  166. #max_parallel_workers_per_gather = 0 # taken from max_worker_processes
  167. #old_snapshot_threshold = -1 # 1min-60d; -1 disables; 0 is immediate
  168. # (change requires restart)
  169. #backend_flush_after = 0 # measured in pages, 0 disables
  170.  
  171.  
  172. #------------------------------------------------------------------------------
  173. # WRITE AHEAD LOG
  174. #------------------------------------------------------------------------------
  175.  
  176. # - Settings -
  177.  
  178. wal_level = replica # minimal, replica, or logical
  179. # (change requires restart)
  180. #fsync = on # flush data to disk for crash safety
  181. # (turning this off can cause
  182. # unrecoverable data corruption)
  183. synchronous_commit = off # synchronization level;
  184. # off, local, remote_write, remote_apply, or on
  185. #wal_sync_method = fsync # the default is the first option
  186. # supported by the operating system:
  187. # open_datasync
  188. # fdatasync (default on Linux)
  189. # fsync
  190. # fsync_writethrough
  191. # open_sync
  192. #full_page_writes = on # recover from partial page writes
  193. #wal_compression = off # enable compression of full-page writes
  194. #wal_log_hints = off # also do full page writes of non-critical updates
  195. # (change requires restart)
  196. #wal_buffers = -1 # min 32kB, -1 sets based on shared_buffers
  197. # (change requires restart)
  198. #wal_writer_delay = 200ms # 1-10000 milliseconds
  199. #wal_writer_flush_after = 1MB # measured in pages, 0 disables
  200.  
  201. #commit_delay = 0 # range 0-100000, in microseconds
  202. #commit_siblings = 5 # range 1-1000
  203.  
  204. # - Checkpoints -
  205.  
  206. #checkpoint_timeout = 5min # range 30s-1d
  207. #max_wal_size = 1GB
  208. #min_wal_size = 80MB
  209. #checkpoint_completion_target = 0.5 # checkpoint target duration, 0.0 - 1.0
  210. #checkpoint_flush_after = 256kB # measured in pages, 0 disables
  211. #checkpoint_warning = 30s # 0 disables
  212.  
  213. # - Archiving -
  214.  
  215. archive_mode = on # enables archiving; off, on, or always
  216. # (change requires restart)
  217. archive_command = '/bin/true' # command to use to archive a logfile segment
  218. # placeholders: %p = path of file to archive
  219. # %f = file name only
  220. # e.g. 'test ! -f /mnt/server/archivedir/%f && cp %p /mnt/server/archivedir/%f'
  221. #archive_timeout = 0 # force a logfile segment switch after this
  222. # number of seconds; 0 disables
  223.  
  224.  
  225. #------------------------------------------------------------------------------
  226. # REPLICATION
  227. #------------------------------------------------------------------------------
  228.  
  229. # - Sending Server(s) -
  230.  
  231. # Set these on the master and on any standby that will send replication data.
  232.  
  233. max_wal_senders = 3 # max number of walsender processes
  234. # (change requires restart)
  235. #wal_keep_segments = 0 # in logfile segments, 16MB each; 0 disables
  236. #wal_sender_timeout = 60s # in milliseconds; 0 disables
  237.  
  238. max_replication_slots = 2 # max number of replication slots
  239. # (change requires restart)
  240. #track_commit_timestamp = off # collect timestamp of transaction commit
  241. # (change requires restart)
  242.  
  243. # - Master Server -
  244.  
  245. # These settings are ignored on a standby server.
  246.  
  247. #synchronous_standby_names = '' # standby servers that provide sync rep
  248. # number of sync standbys and comma-separated list of application_name
  249. # from standby(s); '*' = all
  250. #vacuum_defer_cleanup_age = 0 # number of xacts by which cleanup is delayed
  251.  
  252. # - Standby Servers -
  253.  
  254. # These settings are ignored on a master server.
  255.  
  256. hot_standby = on # "on" allows queries during recovery
  257. # (change requires restart)
  258. #max_standby_archive_delay = 30s # max delay before canceling queries
  259. # when reading WAL from archive;
  260. # -1 allows indefinite delay
  261. #max_standby_streaming_delay = 30s # max delay before canceling queries
  262. # when reading streaming WAL;
  263. # -1 allows indefinite delay
  264. #wal_receiver_status_interval = 10s # send replies at least this often
  265. # 0 disables
  266. #hot_standby_feedback = off # send info from standby to prevent
  267. # query conflicts
  268. #wal_receiver_timeout = 60s # time that receiver waits for
  269. # communication from master
  270. # in milliseconds; 0 disables
  271. #wal_retrieve_retry_interval = 5s # time to wait before retrying to
  272. # retrieve WAL after a failed attempt
  273.  
  274.  
  275. #------------------------------------------------------------------------------
  276. # QUERY TUNING
  277. #------------------------------------------------------------------------------
  278.  
  279. # - Planner Method Configuration -
  280.  
  281. #enable_bitmapscan = on
  282. #enable_hashagg = on
  283. #enable_hashjoin = on
  284. #enable_indexscan = on
  285. #enable_indexonlyscan = on
  286. #enable_material = on
  287. #enable_mergejoin = on
  288. #enable_nestloop = on
  289. #enable_seqscan = on
  290. #enable_sort = on
  291. #enable_tidscan = on
  292.  
  293. # - Planner Cost Constants -
  294.  
  295. #seq_page_cost = 1.0 # measured on an arbitrary scale
  296. #random_page_cost = 4.0 # same scale as above
  297. #cpu_tuple_cost = 0.01 # same scale as above
  298. #cpu_index_tuple_cost = 0.005 # same scale as above
  299. #cpu_operator_cost = 0.0025 # same scale as above
  300. #parallel_tuple_cost = 0.1 # same scale as above
  301. #parallel_setup_cost = 1000.0 # same scale as above
  302. #min_parallel_relation_size = 8MB
  303. #effective_cache_size = 4GB
  304.  
  305. # - Genetic Query Optimizer -
  306.  
  307. #geqo = on
  308. #geqo_threshold = 12
  309. #geqo_effort = 5 # range 1-10
  310. #geqo_pool_size = 0 # selects default based on effort
  311. #geqo_generations = 0 # selects default based on effort
  312. #geqo_selection_bias = 2.0 # range 1.5-2.0
  313. #geqo_seed = 0.0 # range 0.0-1.0
  314.  
  315. # - Other Planner Options -
  316.  
  317. #default_statistics_target = 100 # range 1-10000
  318. #constraint_exclusion = partition # on, off, or partition
  319. #cursor_tuple_fraction = 0.1 # range 0.0-1.0
  320. #from_collapse_limit = 8
  321. #join_collapse_limit = 8 # 1 disables collapsing of explicit
  322. # JOIN clauses
  323. #force_parallel_mode = off
  324.  
  325.  
  326. #------------------------------------------------------------------------------
  327. # ERROR REPORTING AND LOGGING
  328. #------------------------------------------------------------------------------
  329.  
  330. # - Where to Log -
  331.  
  332. log_destination = 'stderr' # Valid values are combinations of
  333. # stderr, csvlog, syslog, and eventlog,
  334. # depending on platform. csvlog
  335. # requires logging_collector to be on.
  336.  
  337. # This is used when logging to stderr:
  338. logging_collector = on # Enable capturing of stderr and csvlog
  339. # into log files. Required to be on for
  340. # csvlogs.
  341. # (change requires restart)
  342.  
  343. # These are only used if logging_collector is on:
  344. log_directory = 'pg_log' # directory where log files are written,
  345. # can be absolute or relative to PGDATA
  346. log_filename = 'postgresql-%a.log' # log file name pattern,
  347. # can include strftime() escapes
  348. #log_file_mode = 0600 # creation mode for log files,
  349. # begin with 0 to use octal notation
  350. log_truncate_on_rotation = on # If on, an existing log file with the
  351. # same name as the new log file will be
  352. # truncated rather than appended to.
  353. # But such truncation only occurs on
  354. # time-driven rotation, not on restarts
  355. # or size-driven rotation. Default is
  356. # off, meaning append to existing files
  357. # in all cases.
  358. log_rotation_age = 1d # Automatic rotation of logfiles will
  359. # happen after that time. 0 disables.
  360. log_rotation_size = 0 # Automatic rotation of logfiles will
  361. # happen after that much log output.
  362. # 0 disables.
  363.  
  364. # These are relevant when logging to syslog:
  365. #syslog_facility = 'LOCAL0'
  366. #syslog_ident = 'postgres'
  367. #syslog_sequence_numbers = on
  368. #syslog_split_messages = on
  369.  
  370. # This is only relevant when logging to eventlog (win32):
  371. # (change requires restart)
  372. #event_source = 'PostgreSQL'
  373.  
  374. # - When to Log -
  375.  
  376. #client_min_messages = notice # values in order of decreasing detail:
  377. # debug5
  378. # debug4
  379. # debug3
  380. # debug2
  381. # debug1
  382. # log
  383. # notice
  384. # warning
  385. # error
  386.  
  387. #log_min_messages = warning # values in order of decreasing detail:
  388. # debug5
  389. # debug4
  390. # debug3
  391. # debug2
  392. # debug1
  393. # info
  394. # notice
  395. # warning
  396. # error
  397. # log
  398. # fatal
  399. # panic
  400.  
  401. #log_min_error_statement = error # values in order of decreasing detail:
  402. # debug5
  403. # debug4
  404. # debug3
  405. # debug2
  406. # debug1
  407. # info
  408. # notice
  409. # warning
  410. # error
  411. # log
  412. # fatal
  413. # panic (effectively off)
  414.  
  415. #log_min_duration_statement = -1 # -1 is disabled, 0 logs all statements
  416. # and their durations, > 0 logs only
  417. # statements running at least this number
  418. # of milliseconds
  419.  
  420.  
  421. # - What to Log -
  422.  
  423. #debug_print_parse = off
  424. #debug_print_rewritten = off
  425. #debug_print_plan = off
  426. #debug_pretty_print = on
  427. #log_checkpoints = off
  428. #log_connections = off
  429. #log_disconnections = off
  430. #log_duration = off
  431. #log_error_verbosity = default # terse, default, or verbose messages
  432. #log_hostname = off
  433. log_line_prefix = '< %m > ' # special values:
  434. # %a = application name
  435. # %u = user name
  436. # %d = database name
  437. # %r = remote host and port
  438. # %h = remote host
  439. # %p = process ID
  440. # %t = timestamp without milliseconds
  441. # %m = timestamp with milliseconds
  442. # %n = timestamp with milliseconds (as a Unix epoch)
  443. # %i = command tag
  444. # %e = SQL state
  445. # %c = session ID
  446. # %l = session line number
  447. # %s = session start timestamp
  448. # %v = virtual transaction ID
  449. # %x = transaction ID (0 if none)
  450. # %q = stop here in non-session
  451. # processes
  452. # %% = '%'
  453. # e.g. '<%u%%%d> '
  454. #log_lock_waits = off # log lock waits >= deadlock_timeout
  455. #log_statement = 'none' # none, ddl, mod, all
  456. #log_replication_commands = off
  457. #log_temp_files = -1 # log temporary files equal or larger
  458. # than the specified size in kilobytes;
  459. # -1 disables, 0 logs all temp files
  460. log_timezone = 'Asia/Yekaterinburg'
  461.  
  462.  
  463. # - Process Title -
  464.  
  465. #cluster_name = '' # added to process titles if nonempty
  466. # (change requires restart)
  467. #update_process_title = on
  468.  
  469.  
  470. #------------------------------------------------------------------------------
  471. # RUNTIME STATISTICS
  472. #------------------------------------------------------------------------------
  473.  
  474. # - Query/Index Statistics Collector -
  475.  
  476. #track_activities = on
  477. #track_counts = on
  478. #track_io_timing = off
  479. #track_functions = none # none, pl, all
  480. #track_activity_query_size = 1024 # (change requires restart)
  481. #stats_temp_directory = 'pg_stat_tmp'
  482.  
  483.  
  484. # - Statistics Monitoring -
  485.  
  486. #log_parser_stats = off
  487. #log_planner_stats = off
  488. #log_executor_stats = off
  489. #log_statement_stats = off
  490.  
  491.  
  492. #------------------------------------------------------------------------------
  493. # AUTOVACUUM PARAMETERS
  494. #------------------------------------------------------------------------------
  495.  
  496. #autovacuum = on # Enable autovacuum subprocess? 'on'
  497. # requires track_counts to also be on.
  498. #log_autovacuum_min_duration = -1 # -1 disables, 0 logs all actions and
  499. # their durations, > 0 logs only
  500. # actions running at least this number
  501. # of milliseconds.
  502. #autovacuum_max_workers = 3 # max number of autovacuum subprocesses
  503. # (change requires restart)
  504. #autovacuum_naptime = 1min # time between autovacuum runs
  505. #autovacuum_vacuum_threshold = 50 # min number of row updates before
  506. # vacuum
  507. #autovacuum_analyze_threshold = 50 # min number of row updates before
  508. # analyze
  509. #autovacuum_vacuum_scale_factor = 0.2 # fraction of table size before vacuum
  510. #autovacuum_analyze_scale_factor = 0.1 # fraction of table size before analyze
  511. #autovacuum_freeze_max_age = 200000000 # maximum XID age before forced vacuum
  512. # (change requires restart)
  513. #autovacuum_multixact_freeze_max_age = 400000000 # maximum multixact age
  514. # before forced vacuum
  515. # (change requires restart)
  516. #autovacuum_vacuum_cost_delay = 20ms # default vacuum cost delay for
  517. # autovacuum, in milliseconds;
  518. # -1 means use vacuum_cost_delay
  519. #autovacuum_vacuum_cost_limit = -1 # default vacuum cost limit for
  520. # autovacuum, -1 means use
  521. # vacuum_cost_limit
  522.  
  523.  
  524. #------------------------------------------------------------------------------
  525. # CLIENT CONNECTION DEFAULTS
  526. #------------------------------------------------------------------------------
  527.  
  528. # - Statement Behavior -
  529.  
  530. #search_path = '"$user", public' # schema names
  531. #default_tablespace = '' # a tablespace name, '' uses the default
  532. #temp_tablespaces = '' # a list of tablespace names, '' uses
  533. # only default tablespace
  534. #check_function_bodies = on
  535. #default_transaction_isolation = 'read committed'
  536. #default_transaction_read_only = off
  537. #default_transaction_deferrable = off
  538. #session_replication_role = 'origin'
  539. #statement_timeout = 0 # in milliseconds, 0 is disabled
  540. #lock_timeout = 0 # in milliseconds, 0 is disabled
  541. #idle_in_transaction_session_timeout = 0 # in milliseconds, 0 is disabled
  542. #vacuum_freeze_min_age = 50000000
  543. #vacuum_freeze_table_age = 150000000
  544. #vacuum_multixact_freeze_min_age = 5000000
  545. #vacuum_multixact_freeze_table_age = 150000000
  546. #bytea_output = 'hex' # hex, escape
  547. #xmlbinary = 'base64'
  548. #xmloption = 'content'
  549. #gin_fuzzy_search_limit = 0
  550. #gin_pending_list_limit = 4MB
  551.  
  552. # - Locale and Formatting -
  553.  
  554. datestyle = 'iso, dmy'
  555. #intervalstyle = 'postgres'
  556. timezone = 'Asia/Yekaterinburg'
  557. #timezone_abbreviations = 'Default' # Select the set of available time zone
  558. # abbreviations. Currently, there are
  559. # Default
  560. # Australia (historical usage)
  561. # India
  562. # You can create your own file in
  563. # share/timezonesets/.
  564. #extra_float_digits = 0 # min -15, max 3
  565. #client_encoding = sql_ascii # actually, defaults to database
  566. # encoding
  567.  
  568. # These settings are initialized by initdb, but they can be changed.
  569. lc_messages = 'ru_RU.UTF-8' # locale for system error message
  570. # strings
  571. lc_monetary = 'ru_RU.UTF-8' # locale for monetary formatting
  572. lc_numeric = 'ru_RU.UTF-8' # locale for number formatting
  573. lc_time = 'ru_RU.UTF-8' # locale for time formatting
  574.  
  575. # default configuration for text search
  576. default_text_search_config = 'pg_catalog.russian'
  577.  
  578. # - Other Defaults -
  579.  
  580. #dynamic_library_path = '$libdir'
  581. #local_preload_libraries = ''
  582. #session_preload_libraries = ''
  583.  
  584.  
  585. #------------------------------------------------------------------------------
  586. # LOCK MANAGEMENT
  587. #------------------------------------------------------------------------------
  588.  
  589. #deadlock_timeout = 1s
  590. max_locks_per_transaction = 150 # min 10
  591. # (change requires restart)
  592. #max_pred_locks_per_transaction = 64 # min 10
  593. # (change requires restart)
  594.  
  595.  
  596. #------------------------------------------------------------------------------
  597. # VERSION/PLATFORM COMPATIBILITY
  598. #------------------------------------------------------------------------------
  599.  
  600. # - Previous PostgreSQL Versions -
  601.  
  602. #array_nulls = on
  603. #backslash_quote = safe_encoding # on, off, or safe_encoding
  604. #default_with_oids = off
  605. escape_string_warning = off
  606. #lo_compat_privileges = off
  607. #operator_precedence_warning = off
  608. #quote_all_identifiers = off
  609. #sql_inheritance = on
  610. standard_conforming_strings = off
  611. #synchronize_seqscans = on
  612.  
  613. # - Other Platforms and Clients -
  614.  
  615. #transform_null_equals = off
  616.  
  617.  
  618. #------------------------------------------------------------------------------
  619. # ERROR HANDLING
  620. #------------------------------------------------------------------------------
  621.  
  622. #exit_on_error = off # terminate session on any error?
  623. #restart_after_crash = on # reinitialize after backend crash?
  624.  
  625.  
  626. #------------------------------------------------------------------------------
  627. # CONFIG FILE INCLUDES
  628. #------------------------------------------------------------------------------
  629.  
  630. # These options allow settings to be loaded from files other than the
  631. # default postgresql.conf.
  632.  
  633. #include_dir = 'conf.d' # include files ending in '.conf' from
  634. # directory 'conf.d'
  635. #include_if_exists = 'exists.conf' # include file only if it exists
  636. #include = 'special.conf' # include file
  637.  
  638.  
  639. #------------------------------------------------------------------------------
  640. # CUSTOMIZED OPTIONS
  641. #------------------------------------------------------------------------------
  642.  
  643. online_analyze.threshold = 50
  644. online_analyze.scale_factor = 0.1
  645. online_analyze.enable = on
  646. online_analyze.verbose = off
  647. online_analyze.min_interval = 10000
  648. online_analyze.table_type = 'temporary'
  649. plantuner.fix_empty_table = false
Add Comment
Please, Sign In to add comment
Public Pastes
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!