<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>postgresql.conf settings</title>
<meta http-equiv="Content-Type" content="utf-8" />
<style type="text/css">
body { font-family: verdana, helvetica, sans-serif; margin: 0px; padding: 0; }
h1 { font-weight: bold; font-size: 150%; border-bottom-style: solid; border-bottom-width: 2px; margin-top: 0px; padding-bottom: 0.5ex; color: #eeeeee; }
h2 { font-size: 130%; padding-bottom: 0.5ex; color: #009ace; border-bottom-style: solid; border-bottom-width: 2px; }
h3 { font-size: 110%; padding-bottom: 0.5ex; color: #000000; }
th { text-align: left; background-color: #009ace; color: #eeeeee; }
#ReportHeader { padding: 10px; background-color: #009ace; color: #eeeeee; border-bottom-style: solid; border-bottom-width: 2px; border-color: #999999; }
#ReportHeader th { width: 25%; white-space: nowrap; vertical-align: top; }
#ReportHeader td { vertical-align: top; color: #eeeeee; }
#ReportNotes { padding: 10px; background-color: #eeeeee; font-size: 80%; border-bottom-style: solid; border-bottom-width: 2px; border-color: #999999; }
.ReportSQL { margin-bottom: 10px; padding: 10px; display: block; background-color: #eeeeee; font-family: monospace; }
#ReportDetails { margin-left: 10px; margin-right: 10px; margin-bottom: 10px; }
#ReportDetails td, th { font-size: 80%; margin-left: 2px; margin-right: 2px; }
#ReportDetails th { border-bottom-color: #777777; border-bottom-style: solid; border-bottom-width: 2px; }
.ReportDetailsOddDataRow { background-color: #dddddd; }
.ReportDetailsEvenDataRow { background-color: #eeeeee; }
.ReportTableHeaderCell { background-color: #dddddd; color: #009ace; vertical-align: top; font-size: 80%; white-space: nowrap; }
.ReportTableValueCell { vertical-align: top; font-size: 80%; white-space: nowrap; }
.ReportTableInfo { font-size: 80%; font-style: italic; }
#ReportFooter { font-weight: bold; font-size: 80%; text-align: right; background-color: #009ace; color: #eeeeee; margin-top: 10px; padding: 2px; border-bottom-style: solid; border-bottom-width: 2px; border-top-style: solid; border-top-width: 2px; border-color: #999999; }
#ReportFooter a { color: #ffffff; text-decoration: none; }
</style>
</head>
<body>
<div id="ReportHeader"><h1>postgresql.conf settings</h1><b>erzeugt: </b>21.08.2008 09:42:30<br /><b>Datenbank: </b>gis auf betula.lr.fal.de:5432<br /></div>
<div id="ReportDetails">
<h2>Abfrageergebnis</h2>
<table>
<tr>
<th class="ReportTableHeaderCell" width="33.3333333333333%">name</th>
<th class="ReportTableHeaderCell" width="33.3333333333333%">setting</th>
<th class="ReportTableHeaderCell" width="33.3333333333333%">description</th>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">add_missing_from</td>
<td class="ReportTableValueCell">off</td>
<td class="ReportTableValueCell">Automatically adds missing table references to FROM clauses.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">allow_system_table_mods</td>
<td class="ReportTableValueCell">off</td>
<td class="ReportTableValueCell">Allows modifications of the structure of system tables.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">archive_command</td>
<td class="ReportTableValueCell"> </td>
<td class="ReportTableValueCell">WAL archiving command.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">archive_timeout</td>
<td class="ReportTableValueCell">0</td>
<td class="ReportTableValueCell">Forces a switch to the next xlog file if a new file has not been started within N seconds.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">array_nulls</td>
<td class="ReportTableValueCell">on</td>
<td class="ReportTableValueCell">Enable input of NULL elements in arrays.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">authentication_timeout</td>
<td class="ReportTableValueCell">1min</td>
<td class="ReportTableValueCell">Sets the maximum time in seconds to complete client authentication.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">autovacuum</td>
<td class="ReportTableValueCell">on</td>
<td class="ReportTableValueCell">Starts the autovacuum subprocess.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">autovacuum_analyze_scale_factor</td>
<td class="ReportTableValueCell">0.1</td>
<td class="ReportTableValueCell">Number of tuple inserts, updates or deletes prior to analyze as a fraction of reltuples.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">autovacuum_analyze_threshold</td>
<td class="ReportTableValueCell">250</td>
<td class="ReportTableValueCell">Minimum number of tuple inserts, updates or deletes prior to analyze.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">autovacuum_freeze_max_age</td>
<td class="ReportTableValueCell">200000000</td>
<td class="ReportTableValueCell">Age at which to autovacuum a table to prevent transaction ID wraparound.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">autovacuum_naptime</td>
<td class="ReportTableValueCell">1min</td>
<td class="ReportTableValueCell">Time to sleep between autovacuum runs, in seconds.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">autovacuum_vacuum_cost_delay</td>
<td class="ReportTableValueCell">-1</td>
<td class="ReportTableValueCell">Vacuum cost delay in milliseconds, for autovacuum.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">autovacuum_vacuum_cost_limit</td>
<td class="ReportTableValueCell">-1</td>
<td class="ReportTableValueCell">Vacuum cost amount available before napping, for autovacuum.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">autovacuum_vacuum_scale_factor</td>
<td class="ReportTableValueCell">0.2</td>
<td class="ReportTableValueCell">Number of tuple updates or deletes prior to vacuum as a fraction of reltuples.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">autovacuum_vacuum_threshold</td>
<td class="ReportTableValueCell">500</td>
<td class="ReportTableValueCell">Minimum number of tuple updates or deletes prior to vacuum.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">backslash_quote</td>
<td class="ReportTableValueCell">safe_encoding</td>
<td class="ReportTableValueCell">Sets whether "\'" is allowed in string literals.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">bgwriter_all_maxpages</td>
<td class="ReportTableValueCell">5</td>
<td class="ReportTableValueCell">Background writer maximum number of all pages to flush per round</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">bgwriter_all_percent</td>
<td class="ReportTableValueCell">0.333</td>
<td class="ReportTableValueCell">Background writer percentage of all buffers to flush per round</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">bgwriter_delay</td>
<td class="ReportTableValueCell">200ms</td>
<td class="ReportTableValueCell">Background writer sleep time between rounds in milliseconds</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">bgwriter_lru_maxpages</td>
<td class="ReportTableValueCell">5</td>
<td class="ReportTableValueCell">Background writer maximum number of LRU pages to flush per round</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">bgwriter_lru_percent</td>
<td class="ReportTableValueCell">1</td>
<td class="ReportTableValueCell">Background writer percentage of LRU buffers to flush per round</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">block_size</td>
<td class="ReportTableValueCell">8192</td>
<td class="ReportTableValueCell">Shows size of a disk block</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">bonjour_name</td>
<td class="ReportTableValueCell"> </td>
<td class="ReportTableValueCell">Sets the Bonjour broadcast service name.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">check_function_bodies</td>
<td class="ReportTableValueCell">on</td>
<td class="ReportTableValueCell">Check function bodies during CREATE FUNCTION.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">checkpoint_segments</td>
<td class="ReportTableValueCell">3</td>
<td class="ReportTableValueCell">Sets the maximum distance in log segments between automatic WAL checkpoints.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">checkpoint_timeout</td>
<td class="ReportTableValueCell">5min</td>
<td class="ReportTableValueCell">Sets the maximum time in seconds between automatic WAL checkpoints.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">checkpoint_warning</td>
<td class="ReportTableValueCell">30s</td>
<td class="ReportTableValueCell">Logs if filling of checkpoint segments happens more frequently than this (in seconds).</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">client_encoding</td>
<td class="ReportTableValueCell">UNICODE</td>
<td class="ReportTableValueCell">Sets the client's character set encoding.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">client_min_messages</td>
<td class="ReportTableValueCell">notice</td>
<td class="ReportTableValueCell">Sets the message levels that are sent to the client.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">commit_delay</td>
<td class="ReportTableValueCell">0</td>
<td class="ReportTableValueCell">Sets the delay in microseconds between transaction commit and flushing WAL to disk.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">commit_siblings</td>
<td class="ReportTableValueCell">5</td>
<td class="ReportTableValueCell">Sets the minimum concurrent open transactions before performing commit_delay.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">config_file</td>
<td class="ReportTableValueCell">/home/postgres/data/postgresql.conf</td>
<td class="ReportTableValueCell">Sets the server's main configuration file.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">constraint_exclusion</td>
<td class="ReportTableValueCell">off</td>
<td class="ReportTableValueCell">Enables the planner to use constraints to optimize queries.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">cpu_index_tuple_cost</td>
<td class="ReportTableValueCell">0.005</td>
<td class="ReportTableValueCell">Sets the planner's estimate of the cost of processing each index entry during an index scan.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">cpu_operator_cost</td>
<td class="ReportTableValueCell">0.0025</td>
<td class="ReportTableValueCell">Sets the planner's estimate of the cost of processing each operator or function call.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">cpu_tuple_cost</td>
<td class="ReportTableValueCell">0.01</td>
<td class="ReportTableValueCell">Sets the planner's estimate of the cost of processing each tuple (row).</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">custom_variable_classes</td>
<td class="ReportTableValueCell"> </td>
<td class="ReportTableValueCell">Sets the list of known custom variable classes.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">data_directory</td>
<td class="ReportTableValueCell">/home/postgres/data</td>
<td class="ReportTableValueCell">Sets the server's data directory.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">DateStyle</td>
<td class="ReportTableValueCell">ISO, DMY</td>
<td class="ReportTableValueCell">Sets the display format for date and time values.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">db_user_namespace</td>
<td class="ReportTableValueCell">off</td>
<td class="ReportTableValueCell">Enables per-database user names.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">deadlock_timeout</td>
<td class="ReportTableValueCell">1s</td>
<td class="ReportTableValueCell">The time in milliseconds to wait on lock before checking for deadlock.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">debug_assertions</td>
<td class="ReportTableValueCell">off</td>
<td class="ReportTableValueCell">Turns on various assertion checks.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">debug_pretty_print</td>
<td class="ReportTableValueCell">off</td>
<td class="ReportTableValueCell">Indents parse and plan tree displays.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">debug_print_parse</td>
<td class="ReportTableValueCell">off</td>
<td class="ReportTableValueCell">Prints the parse tree to the server log.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">debug_print_plan</td>
<td class="ReportTableValueCell">off</td>
<td class="ReportTableValueCell">Prints the execution plan to server log.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">debug_print_rewritten</td>
<td class="ReportTableValueCell">off</td>
<td class="ReportTableValueCell">Prints the parse tree after rewriting to server log.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">default_statistics_target</td>
<td class="ReportTableValueCell">10</td>
<td class="ReportTableValueCell">Sets the default statistics target.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">default_tablespace</td>
<td class="ReportTableValueCell"> </td>
<td class="ReportTableValueCell">Sets the default tablespace to create tables and indexes in.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">default_transaction_isolation</td>
<td class="ReportTableValueCell">read committed</td>
<td class="ReportTableValueCell">Sets the transaction isolation level of each new transaction.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">default_transaction_read_only</td>
<td class="ReportTableValueCell">off</td>
<td class="ReportTableValueCell">Sets the default read-only status of new transactions.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">default_with_oids</td>
<td class="ReportTableValueCell">off</td>
<td class="ReportTableValueCell">Create new tables with OIDs by default.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">dynamic_library_path</td>
<td class="ReportTableValueCell">$libdir</td>
<td class="ReportTableValueCell">Sets the path for dynamically loadable modules.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">effective_cache_size</td>
<td class="ReportTableValueCell">500MB</td>
<td class="ReportTableValueCell">Sets the planner's assumption about size of the disk cache.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">enable_bitmapscan</td>
<td class="ReportTableValueCell">on</td>
<td class="ReportTableValueCell">Enables the planner's use of bitmap-scan plans.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">enable_hashagg</td>
<td class="ReportTableValueCell">on</td>
<td class="ReportTableValueCell">Enables the planner's use of hashed aggregation plans.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">enable_hashjoin</td>
<td class="ReportTableValueCell">on</td>
<td class="ReportTableValueCell">Enables the planner's use of hash join plans.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">enable_indexscan</td>
<td class="ReportTableValueCell">on</td>
<td class="ReportTableValueCell">Enables the planner's use of index-scan plans.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">enable_mergejoin</td>
<td class="ReportTableValueCell">on</td>
<td class="ReportTableValueCell">Enables the planner's use of merge join plans.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">enable_nestloop</td>
<td class="ReportTableValueCell">on</td>
<td class="ReportTableValueCell">Enables the planner's use of nested-loop join plans.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">enable_seqscan</td>
<td class="ReportTableValueCell">on</td>
<td class="ReportTableValueCell">Enables the planner's use of sequential-scan plans.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">enable_sort</td>
<td class="ReportTableValueCell">on</td>
<td class="ReportTableValueCell">Enables the planner's use of explicit sort steps.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">enable_tidscan</td>
<td class="ReportTableValueCell">on</td>
<td class="ReportTableValueCell">Enables the planner's use of TID scan plans.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">escape_string_warning</td>
<td class="ReportTableValueCell">on</td>
<td class="ReportTableValueCell">Warn about backslash escapes in ordinary string literals.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">explain_pretty_print</td>
<td class="ReportTableValueCell">on</td>
<td class="ReportTableValueCell">Uses the indented output format for EXPLAIN VERBOSE.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">external_pid_file</td>
<td class="ReportTableValueCell"> </td>
<td class="ReportTableValueCell">Writes the postmaster PID to the specified file.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">extra_float_digits</td>
<td class="ReportTableValueCell">0</td>
<td class="ReportTableValueCell">Sets the number of digits displayed for floating-point values.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">from_collapse_limit</td>
<td class="ReportTableValueCell">8</td>
<td class="ReportTableValueCell">Sets the FROM-list size beyond which subqueries are not collapsed.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">fsync</td>
<td class="ReportTableValueCell">on</td>
<td class="ReportTableValueCell">Forces synchronization of updates to disk.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">full_page_writes</td>
<td class="ReportTableValueCell">on</td>
<td class="ReportTableValueCell">Writes full pages to WAL when first modified after a checkpoint.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">geqo</td>
<td class="ReportTableValueCell">on</td>
<td class="ReportTableValueCell">Enables genetic query optimization.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">geqo_effort</td>
<td class="ReportTableValueCell">5</td>
<td class="ReportTableValueCell">GEQO: effort is used to set the default for other GEQO parameters.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">geqo_generations</td>
<td class="ReportTableValueCell">0</td>
<td class="ReportTableValueCell">GEQO: number of iterations of the algorithm.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">geqo_pool_size</td>
<td class="ReportTableValueCell">0</td>
<td class="ReportTableValueCell">GEQO: number of individuals in the population.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">geqo_selection_bias</td>
<td class="ReportTableValueCell">2</td>
<td class="ReportTableValueCell">GEQO: selective pressure within the population.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">geqo_threshold</td>
<td class="ReportTableValueCell">12</td>
<td class="ReportTableValueCell">Sets the threshold of FROM items beyond which GEQO is used.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">gin_fuzzy_search_limit</td>
<td class="ReportTableValueCell">0</td>
<td class="ReportTableValueCell">Sets the maximum allowed result for exact search by GIN.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">hba_file</td>
<td class="ReportTableValueCell">/home/postgres/data/pg_hba.conf</td>
<td class="ReportTableValueCell">Sets the server's "hba" configuration file</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">ident_file</td>
<td class="ReportTableValueCell">/home/postgres/data/pg_ident.conf</td>
<td class="ReportTableValueCell">Sets the server's "ident" configuration file</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">ignore_system_indexes</td>
<td class="ReportTableValueCell">off</td>
<td class="ReportTableValueCell">Disables reading from system indexes.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">integer_datetimes</td>
<td class="ReportTableValueCell">on</td>
<td class="ReportTableValueCell">Datetimes are integer based.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">join_collapse_limit</td>
<td class="ReportTableValueCell">8</td>
<td class="ReportTableValueCell">Sets the FROM-list size beyond which JOIN constructs are not flattened.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">krb_caseins_users</td>
<td class="ReportTableValueCell">off</td>
<td class="ReportTableValueCell">Sets whether Kerberos user names should be treated as case-insensitive.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">krb_server_hostname</td>
<td class="ReportTableValueCell"> </td>
<td class="ReportTableValueCell">Sets the hostname of the Kerberos server.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">krb_server_keyfile</td>
<td class="ReportTableValueCell">FILE:/usr/etc/postgresql/krb5.keytab</td>
<td class="ReportTableValueCell">Sets the location of the Kerberos server key file.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">krb_srvname</td>
<td class="ReportTableValueCell">postgres</td>
<td class="ReportTableValueCell">Sets the name of the Kerberos service.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">lc_collate</td>
<td class="ReportTableValueCell">de_DE.UTF-8</td>
<td class="ReportTableValueCell">Shows the collation order locale.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">lc_ctype</td>
<td class="ReportTableValueCell">de_DE.UTF-8</td>
<td class="ReportTableValueCell">Shows the character classification and case conversion locale.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">lc_messages</td>
<td class="ReportTableValueCell">de_DE.UTF-8</td>
<td class="ReportTableValueCell">Sets the language in which messages are displayed.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">lc_monetary</td>
<td class="ReportTableValueCell">de_DE.UTF-8</td>
<td class="ReportTableValueCell">Sets the locale for formatting monetary amounts.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">lc_numeric</td>
<td class="ReportTableValueCell">de_DE.UTF-8</td>
<td class="ReportTableValueCell">Sets the locale for formatting numbers.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">lc_time</td>
<td class="ReportTableValueCell">de_DE.UTF-8</td>
<td class="ReportTableValueCell">Sets the locale for formatting date and time values.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">listen_addresses</td>
<td class="ReportTableValueCell">*</td>
<td class="ReportTableValueCell">Sets the host name or IP address(es) to listen to.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">local_preload_libraries</td>
<td class="ReportTableValueCell"> </td>
<td class="ReportTableValueCell">Lists shared libraries to preload into each backend.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">log_connections</td>
<td class="ReportTableValueCell">off</td>
<td class="ReportTableValueCell">Logs each successful connection.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">log_destination</td>
<td class="ReportTableValueCell">stderr</td>
<td class="ReportTableValueCell">Sets the destination for server log output.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">log_directory</td>
<td class="ReportTableValueCell">pg_log</td>
<td class="ReportTableValueCell">Sets the destination directory for log files.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">log_disconnections</td>
<td class="ReportTableValueCell">off</td>
<td class="ReportTableValueCell">Logs end of a session, including duration.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">log_duration</td>
<td class="ReportTableValueCell">off</td>
<td class="ReportTableValueCell">Logs the duration of each completed SQL statement.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">log_error_verbosity</td>
<td class="ReportTableValueCell">default</td>
<td class="ReportTableValueCell">Sets the verbosity of logged messages.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">log_executor_stats</td>
<td class="ReportTableValueCell">off</td>
<td class="ReportTableValueCell">Writes executor performance statistics to the server log.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">log_filename</td>
<td class="ReportTableValueCell">postgresql-%Y-%m-%d_%H%M%S.log</td>
<td class="ReportTableValueCell">Sets the file name pattern for log files.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">log_hostname</td>
<td class="ReportTableValueCell">off</td>
<td class="ReportTableValueCell">Logs the host name in the connection logs.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">log_line_prefix</td>
<td class="ReportTableValueCell">%t %d %u </td>
<td class="ReportTableValueCell">Controls information prefixed to each log line</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">log_min_duration_statement</td>
<td class="ReportTableValueCell">-1</td>
<td class="ReportTableValueCell">Sets the minimum execution time in milliseconds above which statements will be logged.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">log_min_error_statement</td>
<td class="ReportTableValueCell">error</td>
<td class="ReportTableValueCell">Causes all statements generating error at or above this level to be logged.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">log_min_messages</td>
<td class="ReportTableValueCell">notice</td>
<td class="ReportTableValueCell">Sets the message levels that are logged.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">log_parser_stats</td>
<td class="ReportTableValueCell">off</td>
<td class="ReportTableValueCell">Writes parser performance statistics to the server log.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">log_planner_stats</td>
<td class="ReportTableValueCell">off</td>
<td class="ReportTableValueCell">Writes planner performance statistics to the server log.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">log_rotation_age</td>
<td class="ReportTableValueCell">1d</td>
<td class="ReportTableValueCell">Automatic log file rotation will occur after N minutes</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">log_rotation_size</td>
<td class="ReportTableValueCell">10MB</td>
<td class="ReportTableValueCell">Automatic log file rotation will occur after N kilobytes</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">log_statement</td>
<td class="ReportTableValueCell">none</td>
<td class="ReportTableValueCell">Sets the type of statements logged.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">log_statement_stats</td>
<td class="ReportTableValueCell">off</td>
<td class="ReportTableValueCell">Writes cumulative performance statistics to the server log.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">log_truncate_on_rotation</td>
<td class="ReportTableValueCell">off</td>
<td class="ReportTableValueCell">Truncate existing log files of same name during log rotation.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">maintenance_work_mem</td>
<td class="ReportTableValueCell">250MB</td>
<td class="ReportTableValueCell">Sets the maximum memory to be used for maintenance operations.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">max_connections</td>
<td class="ReportTableValueCell">100</td>
<td class="ReportTableValueCell">Sets the maximum number of concurrent connections.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">max_files_per_process</td>
<td class="ReportTableValueCell">1000</td>
<td class="ReportTableValueCell">Sets the maximum number of simultaneously open files for each server process.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">max_fsm_pages</td>
<td class="ReportTableValueCell">700000</td>
<td class="ReportTableValueCell">Sets the maximum number of disk pages for which free space is tracked.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">max_fsm_relations</td>
<td class="ReportTableValueCell">7000</td>
<td class="ReportTableValueCell">Sets the maximum number of tables and indexes for which free space is tracked.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">max_function_args</td>
<td class="ReportTableValueCell">100</td>
<td class="ReportTableValueCell">Shows the maximum number of function arguments.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">max_identifier_length</td>
<td class="ReportTableValueCell">63</td>
<td class="ReportTableValueCell">Shows the maximum identifier length</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">max_index_keys</td>
<td class="ReportTableValueCell">32</td>
<td class="ReportTableValueCell">Shows the maximum number of index keys.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">max_locks_per_transaction</td>
<td class="ReportTableValueCell">64</td>
<td class="ReportTableValueCell">Sets the maximum number of locks per transaction.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">max_prepared_transactions</td>
<td class="ReportTableValueCell">5</td>
<td class="ReportTableValueCell">Sets the maximum number of simultaneously prepared transactions.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">max_stack_depth</td>
<td class="ReportTableValueCell">2MB</td>
<td class="ReportTableValueCell">Sets the maximum stack depth, in kilobytes.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">password_encryption</td>
<td class="ReportTableValueCell">on</td>
<td class="ReportTableValueCell">Encrypt passwords.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">port</td>
<td class="ReportTableValueCell">5432</td>
<td class="ReportTableValueCell">Sets the TCP port the server listens on.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">post_auth_delay</td>
<td class="ReportTableValueCell">0</td>
<td class="ReportTableValueCell">Waits N seconds on connection startup after authentication.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">pre_auth_delay</td>
<td class="ReportTableValueCell">0</td>
<td class="ReportTableValueCell">no description available</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">random_page_cost</td>
<td class="ReportTableValueCell">4</td>
<td class="ReportTableValueCell">Sets the planner's estimate of the cost of a nonsequentially fetched disk page.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">redirect_stderr</td>
<td class="ReportTableValueCell">on</td>
<td class="ReportTableValueCell">Start a subprocess to capture stderr output into log files.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">regex_flavor</td>
<td class="ReportTableValueCell">advanced</td>
<td class="ReportTableValueCell">Sets the regular expression "flavor".</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">search_path</td>
<td class="ReportTableValueCell">"$user",public</td>
<td class="ReportTableValueCell">Sets the schema search order for names that are not schema-qualified.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">seq_page_cost</td>
<td class="ReportTableValueCell">1</td>
<td class="ReportTableValueCell">Sets the planner's estimate of the cost of a sequentially fetched disk page.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">server_encoding</td>
<td class="ReportTableValueCell">UTF8</td>
<td class="ReportTableValueCell">Sets the server (database) character set encoding.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">server_version</td>
<td class="ReportTableValueCell">8.2.6</td>
<td class="ReportTableValueCell">Shows the server version.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">server_version_num</td>
<td class="ReportTableValueCell">80206</td>
<td class="ReportTableValueCell">Shows the server version as an integer.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">shared_buffers</td>
<td class="ReportTableValueCell">3500MB</td>
<td class="ReportTableValueCell">Sets the number of shared memory buffers used by the server.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">shared_preload_libraries</td>
<td class="ReportTableValueCell"> </td>
<td class="ReportTableValueCell">Lists shared libraries to preload into server.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">silent_mode</td>
<td class="ReportTableValueCell">on</td>
<td class="ReportTableValueCell">Runs the server silently.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">sql_inheritance</td>
<td class="ReportTableValueCell">on</td>
<td class="ReportTableValueCell">Causes subtables to be included by default in various commands.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">ssl</td>
<td class="ReportTableValueCell">off</td>
<td class="ReportTableValueCell">Enables SSL connections.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">standard_conforming_strings</td>
<td class="ReportTableValueCell">off</td>
<td class="ReportTableValueCell">'...' strings treat backslashes literally.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">statement_timeout</td>
<td class="ReportTableValueCell">0</td>
<td class="ReportTableValueCell">Sets the maximum allowed duration (in milliseconds) of any statement.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">stats_block_level</td>
<td class="ReportTableValueCell">off</td>
<td class="ReportTableValueCell">Collects block-level statistics on database activity.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">stats_command_string</td>
<td class="ReportTableValueCell">on</td>
<td class="ReportTableValueCell">Collects information about executing commands.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">stats_reset_on_server_start</td>
<td class="ReportTableValueCell">off</td>
<td class="ReportTableValueCell">Zeroes collected statistics on server restart.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">stats_row_level</td>
<td class="ReportTableValueCell">on</td>
<td class="ReportTableValueCell">Collects row-level statistics on database activity.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">stats_start_collector</td>
<td class="ReportTableValueCell">on</td>
<td class="ReportTableValueCell">Starts the server statistics-collection subprocess.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">superuser_reserved_connections</td>
<td class="ReportTableValueCell">3</td>
<td class="ReportTableValueCell">Sets the number of connection slots reserved for superusers.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">syslog_facility</td>
<td class="ReportTableValueCell">LOCAL0</td>
<td class="ReportTableValueCell">Sets the syslog "facility" to be used when syslog enabled.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">syslog_ident</td>
<td class="ReportTableValueCell">postgres</td>
<td class="ReportTableValueCell">Sets the program name used to identify PostgreSQL messages in syslog.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">tcp_keepalives_count</td>
<td class="ReportTableValueCell">9</td>
<td class="ReportTableValueCell">Maximum number of TCP keepalive retransmits.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">tcp_keepalives_idle</td>
<td class="ReportTableValueCell">7200</td>
<td class="ReportTableValueCell">Seconds between issuing TCP keepalives.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">tcp_keepalives_interval</td>
<td class="ReportTableValueCell">75</td>
<td class="ReportTableValueCell">Seconds between TCP keepalive retransmits.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">temp_buffers</td>
<td class="ReportTableValueCell">12800</td>
<td class="ReportTableValueCell">Sets the maximum number of temporary buffers used by each session.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">TimeZone</td>
<td class="ReportTableValueCell">Europe/Berlin</td>
<td class="ReportTableValueCell">Sets the time zone for displaying and interpreting time stamps.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">timezone_abbreviations</td>
<td class="ReportTableValueCell">Default</td>
<td class="ReportTableValueCell">Selects a file of time zone abbreviations</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">trace_notify</td>
<td class="ReportTableValueCell">off</td>
<td class="ReportTableValueCell">Generates debugging output for LISTEN and NOTIFY.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">trace_sort</td>
<td class="ReportTableValueCell">off</td>
<td class="ReportTableValueCell">Emit information about resource usage in sorting.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">transaction_isolation</td>
<td class="ReportTableValueCell">read committed</td>
<td class="ReportTableValueCell">Sets the current transaction's isolation level.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">transaction_read_only</td>
<td class="ReportTableValueCell">off</td>
<td class="ReportTableValueCell">Sets the current transaction's read-only status.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">transform_null_equals</td>
<td class="ReportTableValueCell">off</td>
<td class="ReportTableValueCell">Treats "expr=NULL" as "expr IS NULL".</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">unix_socket_directory</td>
<td class="ReportTableValueCell"> </td>
<td class="ReportTableValueCell">Sets the directory where the Unix-domain socket will be created.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">unix_socket_group</td>
<td class="ReportTableValueCell"> </td>
<td class="ReportTableValueCell">Sets the owning group of the Unix-domain socket.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">unix_socket_permissions</td>
<td class="ReportTableValueCell">511</td>
<td class="ReportTableValueCell">Sets the access permissions of the Unix-domain socket.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">update_process_title</td>
<td class="ReportTableValueCell">on</td>
<td class="ReportTableValueCell">Updates the process title to show the active SQL command.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">vacuum_cost_delay</td>
<td class="ReportTableValueCell">0</td>
<td class="ReportTableValueCell">Vacuum cost delay in milliseconds.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">vacuum_cost_limit</td>
<td class="ReportTableValueCell">200</td>
<td class="ReportTableValueCell">Vacuum cost amount available before napping.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">vacuum_cost_page_dirty</td>
<td class="ReportTableValueCell">20</td>
<td class="ReportTableValueCell">Vacuum cost for a page dirtied by vacuum.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">vacuum_cost_page_hit</td>
<td class="ReportTableValueCell">1</td>
<td class="ReportTableValueCell">Vacuum cost for a page found in the buffer cache.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">vacuum_cost_page_miss</td>
<td class="ReportTableValueCell">10</td>
<td class="ReportTableValueCell">Vacuum cost for a page not found in the buffer cache.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">vacuum_freeze_min_age</td>
<td class="ReportTableValueCell">100000000</td>
<td class="ReportTableValueCell">Minimum age at which VACUUM should freeze a table row.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">wal_buffers</td>
<td class="ReportTableValueCell">64kB</td>
<td class="ReportTableValueCell">Sets the number of disk-page buffers in shared memory for WAL.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">wal_sync_method</td>
<td class="ReportTableValueCell">fdatasync</td>
<td class="ReportTableValueCell">Selects the method used for forcing WAL updates out to disk.</td>
</tr>
<tr class="ReportDetailsEvenDataRow">
<td class="ReportTableValueCell">work_mem</td>
<td class="ReportTableValueCell">400MB</td>
<td class="ReportTableValueCell">Sets the maximum memory to be used for query workspaces.</td>
</tr>
<tr class="ReportDetailsOddDataRow">
<td class="ReportTableValueCell">zero_damaged_pages</td>
<td class="ReportTableValueCell">off</td>
<td class="ReportTableValueCell">Continues processing past damaged page headers.</td>
</tr>
</table>
<br />
<p class="ReportTableInfo">176 rows with 3 columns retrieved.</p>
</div>
<div id="ReportFooter">
Bericht erstellt von <a href="http://www.pgadmin.org/">pgAdmin</a></div>
<br />
</body>
</html>