Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on May 5th, 2012  |  syntax: None  |  size: 19.57 KB  |  hits: 10  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. name               |      setting       |                                                          description                                                          
  2. ---------------------------------+--------------------+-------------------------------------------------------------------------------------------------------------------------------
  3.  add_missing_from                | off                | Automatically adds missing table references to FROM clauses.
  4.  allow_system_table_mods         | off                | Allows modifications of the structure of system tables.
  5.  archive_command                 | (disabled)         | Sets the shell command that will be called to archive a WAL file.
  6.  archive_mode                    | off                | Allows archiving of WAL files using archive_command.
  7.  archive_timeout                 | 0                  | Forces a switch to the next xlog file if a new file has not been started within N seconds.
  8.  array_nulls                     | on                 | Enable input of NULL elements in arrays.
  9.  authentication_timeout          | 1min               | Sets the maximum allowed time to complete client authentication.
  10.  autovacuum                      | on                 | Starts the autovacuum subprocess.
  11.  autovacuum_analyze_scale_factor | 0.1                | Number of tuple inserts, updates or deletes prior to analyze as a fraction of reltuples.
  12.  autovacuum_analyze_threshold    | 50                 | Minimum number of tuple inserts, updates or deletes prior to analyze.
  13.  autovacuum_freeze_max_age       | 200000000          | Age at which to autovacuum a table to prevent transaction ID wraparound.
  14.  autovacuum_max_workers          | 3                  | Sets the maximum number of simultaneously running autovacuum worker processes.
  15.  autovacuum_naptime              | 1min               | Time to sleep between autovacuum runs.
  16.  autovacuum_vacuum_cost_delay    | 20ms               | Vacuum cost delay in milliseconds, for autovacuum.
  17.  autovacuum_vacuum_cost_limit    | -1                 | Vacuum cost amount available before napping, for autovacuum.
  18.  autovacuum_vacuum_scale_factor  | 0.2                | Number of tuple updates or deletes prior to vacuum as a fraction of reltuples.
  19.  autovacuum_vacuum_threshold     | 50                 | Minimum number of tuple updates or deletes prior to vacuum.
  20.  backslash_quote                 | safe_encoding      | Sets whether "\'" is allowed in string literals.
  21.  bgwriter_delay                  | 200ms              | Background writer sleep time between rounds.
  22.  bgwriter_lru_maxpages           | 100                | Background writer maximum number of LRU pages to flush per round.
  23.  bgwriter_lru_multiplier         | 2                  | Background writer multiplier on average buffers to scan per round.
  24.  block_size                      | 8192               | Shows the size of a disk block.
  25.  bonjour_name                    |                    | Sets the Bonjour broadcast service name.
  26.  check_function_bodies           | on                 | Check function bodies during CREATE FUNCTION.
  27.  checkpoint_completion_target    | 0.5                | Time spent flushing dirty buffers during checkpoint, as fraction of checkpoint interval.
  28.  checkpoint_segments             | 64                 | Sets the maximum distance in log segments between automatic WAL checkpoints.
  29.  checkpoint_timeout              | 5min               | Sets the maximum time between automatic WAL checkpoints.
  30.  checkpoint_warning              | 30s                | Enables warnings if checkpoint segments are filled more frequently than this.
  31.  client_encoding                 | UTF8               | Sets the client's character set encoding.
  32.  client_min_messages             | notice             | Sets the message levels that are sent to the client.
  33.  commit_delay                    | 0                  | Sets the delay in microseconds between transaction commit and flushing WAL to disk.
  34.  commit_siblings                 | 300                | Sets the minimum concurrent open transactions before performing commit_delay.
  35.  constraint_exclusion            | off                | Enables the planner to use constraints to optimize queries.
  36.  cpu_index_tuple_cost            | 0.005              | Sets the planner's estimate of the cost of processing each index entry during an index scan.
  37.  cpu_operator_cost               | 0.0025             | Sets the planner's estimate of the cost of processing each operator or function call.
  38.  cpu_tuple_cost                  | 0.01               | Sets the planner's estimate of the cost of processing each tuple (row).
  39.  custom_variable_classes         |                    | Sets the list of known custom variable classes.
  40.  DateStyle                       | ISO, MDY           | Sets the display format for date and time values.
  41.  db_user_namespace               | off                | Enables per-database user names.
  42.  deadlock_timeout                | 2s                 | Sets the time to wait on a lock before checking for deadlock.
  43.  debug_assertions                | off                | Turns on various assertion checks.
  44.  debug_pretty_print              | off                | Indents parse and plan tree displays.
  45.  debug_print_parse               | off                | Prints the parse tree to the server log.
  46.  debug_print_plan                | off                | Prints the execution plan to server log.
  47.  debug_print_rewritten           | off                | Prints the parse tree after rewriting to server log.
  48.  default_statistics_target       | 30                 | Sets the default statistics target.
  49.  default_tablespace              |                    | Sets the default tablespace to create tables and indexes in.
  50.  default_text_search_config      | pg_catalog.english | Sets default text search configuration.
  51.  default_transaction_isolation   | read committed     | Sets the transaction isolation level of each new transaction.
  52.  default_transaction_read_only   | off                | Sets the default read-only status of new transactions.
  53.  default_with_oids               | off                | Create new tables with OIDs by default.
  54.  effective_cache_size            | 768MB              | Sets the planner's assumption about the size of the disk cache.
  55.  enable_bitmapscan               | on                 | Enables the planner's use of bitmap-scan plans.
  56.  enable_hashagg                  | on                 | Enables the planner's use of hashed aggregation plans.
  57.  enable_hashjoin                 | on                 | Enables the planner's use of hash join plans.
  58.  enable_indexscan                | on                 | Enables the planner's use of index-scan plans.
  59.  enable_mergejoin                | on                 | Enables the planner's use of merge join plans.
  60.  enable_nestloop                 | on                 | Enables the planner's use of nested-loop join plans.
  61.  enable_seqscan                  | on                 | Enables the planner's use of sequential-scan plans.
  62.  enable_sort                     | on                 | Enables the planner's use of explicit sort steps.
  63.  enable_tidscan                  | on                 | Enables the planner's use of TID scan plans.
  64.  escape_string_warning           | on                 | Warn about backslash escapes in ordinary string literals.
  65.  explain_pretty_print            | on                 | Uses the indented output format for EXPLAIN VERBOSE.
  66.  extra_float_digits              | 0                  | Sets the number of digits displayed for floating-point values.
  67.  from_collapse_limit             | 8                  | Sets the FROM-list size beyond which subqueries are not collapsed.
  68.  fsync                           | off                | Forces synchronization of updates to disk.
  69.  full_page_writes                | on                 | Writes full pages to WAL when first modified after a checkpoint.
  70.  geqo                            | on                 | Enables genetic query optimization.
  71.  geqo_effort                     | 5                  | GEQO: effort is used to set the default for other GEQO parameters.
  72.  geqo_generations                | 0                  | GEQO: number of iterations of the algorithm.
  73.  geqo_pool_size                  | 0                  | GEQO: number of individuals in the population.
  74.  geqo_selection_bias             | 2                  | GEQO: selective pressure within the population.
  75.  geqo_threshold                  | 12                 | Sets the threshold of FROM items beyond which GEQO is used.
  76.  gin_fuzzy_search_limit          | 0                  | Sets the maximum allowed result for exact search by GIN.
  77.  ignore_system_indexes           | off                | Disables reading from system indexes.
  78.  integer_datetimes               | on                 | Datetimes are integer based.
  79.  join_collapse_limit             | 8                  | Sets the FROM-list size beyond which JOIN constructs are not flattened.
  80.  krb_caseins_users               | off                | Sets whether Kerberos and GSSAPI user names should be treated as case-insensitive.
  81.  krb_server_hostname             |                    | Sets the hostname of the Kerberos server.
  82.  krb_srvname                     | postgres           | Sets the name of the Kerberos service.
  83.  lc_collate                      | en_US.UTF-8        | Shows the collation order locale.
  84.  lc_ctype                        | en_US.UTF-8        | Shows the character classification and case conversion locale.
  85.  lc_messages                     | en_US.UTF-8        | Sets the language in which messages are displayed.
  86.  lc_monetary                     | en_US.UTF-8        | Sets the locale for formatting monetary amounts.
  87.  lc_numeric                      | en_US.UTF-8        | Sets the locale for formatting numbers.
  88.  lc_time                         | en_US.UTF-8        | Sets the locale for formatting date and time values.
  89.  listen_addresses                |                    | Sets the host name or IP address(es) to listen to.
  90.  local_preload_libraries         |                    | Lists shared libraries to preload into each backend.
  91.  log_autovacuum_min_duration     | -1                 | Sets the minimum execution time above which autovacuum actions will be logged.
  92.  log_checkpoints                 | off                | Logs each checkpoint.
  93.  log_connections                 | off                | Logs each successful connection.
  94.  log_destination                 | stderr             | Sets the destination for server log output.
  95.  log_disconnections              | off                | Logs end of a session, including duration.
  96.  log_duration                    | off                | Logs the duration of each completed SQL statement.
  97.  log_error_verbosity             | default            | Sets the verbosity of logged messages.
  98.  log_executor_stats              | off                | Writes executor performance statistics to the server log.
  99.  log_hostname                    | off                | Logs the host name in the connection logs.
  100.  log_line_prefix                 | %t                 | Controls information prefixed to each log line.
  101.  log_lock_waits                  | off                | Logs long lock waits.
  102.  log_min_duration_statement      | 80ms               | Sets the minimum execution time above which statements will be logged.
  103.  log_min_error_statement         | error              | Causes all statements generating error at or above this level to be logged.
  104.  log_min_messages                | notice             | Sets the message levels that are logged.
  105.  log_parser_stats                | off                | Writes parser performance statistics to the server log.
  106.  log_planner_stats               | off                | Writes planner performance statistics to the server log.
  107.  log_rotation_age                | 1d                 | Automatic log file rotation will occur after N minutes.
  108.  log_rotation_size               | 10MB               | Automatic log file rotation will occur after N kilobytes.
  109.  log_statement                   | none               | Sets the type of statements logged.
  110.  log_statement_stats             | off                | Writes cumulative performance statistics to the server log.
  111.  log_temp_files                  | -1                 | Log the use of temporary files larger than this number of kilobytes.
  112.  log_timezone                    | localtime          | Sets the time zone to use in log messages.
  113.  log_truncate_on_rotation        | off                | Truncate existing log files of same name during log rotation.
  114.  logging_collector               | off                | Start a subprocess to capture stderr output and/or csvlogs into log files.
  115.  maintenance_work_mem            | 768MB              | Sets the maximum memory to be used for maintenance operations.
  116.  max_connections                 | 101                | Sets the maximum number of concurrent connections.
  117.  max_files_per_process           | 1000               | Sets the maximum number of simultaneously open files for each server process.
  118.  max_fsm_pages                   | 153600             | Sets the maximum number of disk pages for which free space is tracked.
  119.  max_fsm_relations               | 1000               | Sets the maximum number of tables and indexes for which free space is tracked.
  120.  max_function_args               | 100                | Shows the maximum number of function arguments.
  121.  max_identifier_length           | 63                 | Shows the maximum identifier length.
  122.  max_index_keys                  | 32                 | Shows the maximum number of index keys.
  123.  max_locks_per_transaction       | 64                 | Sets the maximum number of locks per transaction.
  124.  max_prepared_transactions       | 5                  | Sets the maximum number of simultaneously prepared transactions.
  125.  max_stack_depth                 | 4MB                | Sets the maximum stack depth, in kilobytes.
  126.  password_encryption             | on                 | Encrypt passwords.
  127.  port                            | 5432               | Sets the TCP port the server listens on.
  128.  post_auth_delay                 | 0                  | Waits N seconds on connection startup after authentication.
  129.  pre_auth_delay                  | 0                  | Waits N seconds on connection startup before authentication.
  130.  random_page_cost                | 4                  | Sets the planner's estimate of the cost of a nonsequentially fetched disk page.
  131.  regex_flavor                    | advanced           | Sets the regular expression "flavor".
  132.  search_path                     | "$user",public     | Sets the schema search order for names that are not schema-qualified.
  133.  seq_page_cost                   | 1                  | Sets the planner's estimate of the cost of a sequentially fetched disk page.
  134.  server_encoding                 | UTF8               | Sets the server (database) character set encoding.
  135.  server_version                  | 8.3.11             | Shows the server version.
  136.  server_version_num              | 80311              | Shows the server version as an integer.
  137.  session_replication_role        | origin             | Sets the session's behavior for triggers and rewrite rules.
  138.  shared_buffers                  | 400MB              | Sets the number of shared memory buffers used by the server.
  139.  silent_mode                     | on                 | Runs the server silently.
  140.  sql_inheritance                 | on                 | Causes subtables to be included by default in various commands.
  141.  ssl                             | off                | Enables SSL connections.
  142.  ssl_renegotiation_limit         | 512MB              | Set the amount of traffic to send and receive before renegotiating the encryption keys.
  143.  standard_conforming_strings     | off                | Causes '...' strings to treat backslashes literally.
  144.  statement_timeout               | 0                  | Sets the maximum allowed duration of any statement.
  145.  superuser_reserved_connections  | 3                  | Sets the number of connection slots reserved for superusers.
  146.  synchronize_seqscans            | on                 | Enable synchronized sequential scans.
  147.  synchronous_commit              | on                 | Sets immediate fsync at commit.
  148.  syslog_facility                 | LOCAL0             | Sets the syslog "facility" to be used when syslog enabled.
  149.  syslog_ident                    | postgres           | Sets the program name used to identify PostgreSQL messages in syslog.
  150.  tcp_keepalives_count            | 0                  | Maximum number of TCP keepalive retransmits.
  151.  tcp_keepalives_idle             | 0                  | Time between issuing TCP keepalives.
  152.  tcp_keepalives_interval         | 0                  | Time between TCP keepalive retransmits.
  153.  temp_buffers                    | 4096               | Sets the maximum number of temporary buffers used by each session.
  154.  temp_tablespaces                |                    | Sets the tablespace(s) to use for temporary tables and sort files.
  155.  TimeZone                        | localtime          | Sets the time zone for displaying and interpreting time stamps.
  156.  timezone_abbreviations          | Default            | Selects a file of time zone abbreviations.
  157.  trace_notify                    | off                | Generates debugging output for LISTEN and NOTIFY.
  158.  trace_sort                      | off                | Emit information about resource usage in sorting.
  159.  track_activities                | on                 | Collects information about executing commands.
  160.  track_counts                    | on                 | Collects statistics on database activity.
  161.  transaction_isolation           | read committed     | Sets the current transaction's isolation level.
  162.  transaction_read_only           | off                | Sets the current transaction's read-only status.
  163.  transform_null_equals           | off                | Treats "expr=NULL" as "expr IS NULL".
  164.  unix_socket_group               |                    | Sets the owning group of the Unix-domain socket.
  165.  unix_socket_permissions         | 511                | Sets the access permissions of the Unix-domain socket.
  166.  update_process_title            | on                 | Updates the process title to show the active SQL command.
  167.  vacuum_cost_delay               | 0                  | Vacuum cost delay in milliseconds.
  168.  vacuum_cost_limit               | 200                | Vacuum cost amount available before napping.
  169.  vacuum_cost_page_dirty          | 20                 | Vacuum cost for a page dirtied by vacuum.
  170.  vacuum_cost_page_hit            | 1                  | Vacuum cost for a page found in the buffer cache.
  171.  vacuum_cost_page_miss           | 10                 | Vacuum cost for a page not found in the buffer cache.
  172.  vacuum_freeze_min_age           | 100000000          | Minimum age at which VACUUM should freeze a table row.
  173.  wal_buffers                     | 8MB                | Sets the number of disk-page buffers in shared memory for WAL.
  174.  wal_sync_method                 | fdatasync          | Selects the method used for forcing WAL updates to disk.
  175.  wal_writer_delay                | 200ms              | WAL writer sleep time between WAL flushes.
  176.  work_mem                        | 512MB              | Sets the maximum memory to be used for query workspaces.
  177.  xmlbinary                       | base64             | Sets how binary values are to be encoded in XML.
  178.  xmloption                       | content            | Sets whether XML data in implicit parsing and serialization operations is to be considered as documents or content fragments.
  179.  zero_damaged_pages              | off                | Continues processing past damaged page headers.
  180. (177 rows)
create a new version of this paste RAW Paste Data