General Configuration

Be careful, this is not the result from reading the postgresql.conf file, but it's the actual configuration available when connecting to database pagila on server localhost:5432 as user guillaume.

Name Actual setting Unit Category Short desc Extra desc Context Vartype Source Min value Max value
autovacuum on Autovacuum Starts the autovacuum subprocess. sighup bool default
autovacuum_analyze_scale_factor 0.1 Autovacuum Number of tuple inserts, updates or deletes prior to analyze as a fraction of reltuples. sighup real default 0 100
autovacuum_analyze_threshold 50 Autovacuum Minimum number of tuple inserts, updates or deletes prior to analyze. sighup integer default 0 2147483647
autovacuum_freeze_max_age 200000000 Autovacuum Age at which to autovacuum a table to prevent transaction ID wraparound. postmaster integer default 100000000 2000000000
autovacuum_max_workers 3 Autovacuum Sets the maximum number of simultaneously running autovacuum worker processes. postmaster integer default 1 536870911
autovacuum_naptime 60 s Autovacuum Time to sleep between autovacuum runs. sighup integer default 1 2147483
autovacuum_vacuum_cost_delay 20 ms Autovacuum Vacuum cost delay in milliseconds, for autovacuum. sighup integer default -1 1000
autovacuum_vacuum_cost_limit -1 Autovacuum Vacuum cost amount available before napping, for autovacuum. sighup integer default -1 10000
autovacuum_vacuum_scale_factor 0.2 Autovacuum Number of tuple updates or deletes prior to vacuum as a fraction of reltuples. sighup real default 0 100
autovacuum_vacuum_threshold 50 Autovacuum Minimum number of tuple updates or deletes prior to vacuum. sighup integer default 0 2147483647
client_encoding UTF8 Client Connection Defaults / Locale and Formatting Sets the client's character set encoding. user string default
DateStyle ISO, DMY Client Connection Defaults / Locale and Formatting Sets the display format for date and time values. Also controls interpretation of ambiguous date inputs. user string configuration file
default_text_search_config pg_catalog.french Client Connection Defaults / Locale and Formatting Sets default text search configuration. user string configuration file
extra_float_digits 0 Client Connection Defaults / Locale and Formatting Sets the number of digits displayed for floating-point values. This affects real, double precision, and geometric data types. The parameter value is added to the standard number of digits (FLT_DIG or DBL_DIG as appropriate). user integer default -15 2
lc_collate fr_FR.UTF-8 Client Connection Defaults / Locale and Formatting Shows the collation order locale. internal string override
lc_ctype fr_FR.UTF-8 Client Connection Defaults / Locale and Formatting Shows the character classification and case conversion locale. internal string override
lc_messages fr_FR.UTF-8 Client Connection Defaults / Locale and Formatting Sets the language in which messages are displayed. superuser string configuration file
lc_monetary fr_FR.UTF-8 Client Connection Defaults / Locale and Formatting Sets the locale for formatting monetary amounts. user string configuration file
lc_numeric fr_FR.UTF-8 Client Connection Defaults / Locale and Formatting Sets the locale for formatting numbers. user string configuration file
lc_time fr_FR.UTF-8 Client Connection Defaults / Locale and Formatting Sets the locale for formatting date and time values. user string configuration file
server_encoding UTF8 Client Connection Defaults / Locale and Formatting Sets the server (database) character set encoding. internal string override
TimeZone Europe/Paris Client Connection Defaults / Locale and Formatting Sets the time zone for displaying and interpreting time stamps. user string command line
timezone_abbreviations Default Client Connection Defaults / Locale and Formatting Selects a file of time zone abbreviations. user string command line
dynamic_library_path $libdir Client Connection Defaults / Other Defaults Sets the path for dynamically loadable modules. If a dynamically loadable module needs to be opened and the specified name does not have a directory component (i.e., the name does not contain a slash), the system will search this path for the specified file. superuser string default
explain_pretty_print on Client Connection Defaults / Other Defaults Uses the indented output format for EXPLAIN VERBOSE. user bool default
gin_fuzzy_search_limit 0 Client Connection Defaults / Other Defaults Sets the maximum allowed result for exact search by GIN. user integer default 0 2147483647
local_preload_libraries Client Connection Defaults / Other Defaults Lists shared libraries to preload into each backend. backend string default
tcp_keepalives_count 9 Client Connection Defaults / Other Defaults Maximum number of TCP keepalive retransmits. This controls the number of consecutive keepalive retransmits that can be lost before a connection is considered dead. A value of 0 uses the system default. user integer default 0 2147483647
tcp_keepalives_idle 7200 s Client Connection Defaults / Other Defaults Time between issuing TCP keepalives. A value of 0 uses the system default. user integer default 0 2147483647
tcp_keepalives_interval 75 s Client Connection Defaults / Other Defaults Time between TCP keepalive retransmits. A value of 0 uses the system default. user integer default 0 2147483647
check_function_bodies on Client Connection Defaults / Statement Behavior Check function bodies during CREATE FUNCTION. user bool default
default_tablespace Client Connection Defaults / Statement Behavior Sets the default tablespace to create tables and indexes in. An empty string selects the database's default tablespace. user string default
default_transaction_isolation read committed Client Connection Defaults / Statement Behavior Sets the transaction isolation level of each new transaction. Each SQL transaction has an isolation level, which can be either "read uncommitted", "read committed", "repeatable read", or "serializable". user string default
default_transaction_read_only off Client Connection Defaults / Statement Behavior Sets the default read-only status of new transactions. user bool default
search_path "$user",public Client Connection Defaults / Statement Behavior Sets the schema search order for names that are not schema-qualified. user string default
session_replication_role origin Client Connection Defaults / Statement Behavior Sets the session's behavior for triggers and rewrite rules. Each session can be either "origin", "replica", or "local". superuser string default
statement_timeout 0 ms Client Connection Defaults / Statement Behavior Sets the maximum allowed duration of any statement. A value of 0 turns off the timeout. user integer default 0 2147483647
temp_tablespaces Client Connection Defaults / Statement Behavior Sets the tablespace(s) to use for temporary tables and sort files. user string default
transaction_isolation read committed Client Connection Defaults / Statement Behavior Sets the current transaction's isolation level. user string override
transaction_read_only off Client Connection Defaults / Statement Behavior Sets the current transaction's read-only status. user bool override
vacuum_freeze_min_age 100000000 Client Connection Defaults / Statement Behavior Minimum age at which VACUUM should freeze a table row. user integer default 0 1000000000
xmlbinary base64 Client Connection Defaults / Statement Behavior Sets how binary values are to be encoded in XML. Valid values are BASE64 and HEX. user string default
xmloption content Client Connection Defaults / Statement Behavior Sets whether XML data in implicit parsing and serialization operations is to be considered as documents or content fragments. Valid values are DOCUMENT and CONTENT. user string default
bonjour_name Connections and Authentication / Connection Settings Sets the Bonjour broadcast service name. postmaster string default
listen_addresses localhost Connections and Authentication / Connection Settings Sets the host name or IP address(es) to listen to. postmaster string default
max_connections 100 Connections and Authentication / Connection Settings Sets the maximum number of concurrent connections. postmaster integer configuration file 1 536870911
port 5432 Connections and Authentication / Connection Settings Sets the TCP port the server listens on. postmaster integer configuration file 1 65535
superuser_reserved_connections 3 Connections and Authentication / Connection Settings Sets the number of connection slots reserved for superusers. postmaster integer default 0 536870911
unix_socket_directory Connections and Authentication / Connection Settings Sets the directory where the Unix-domain socket will be created. postmaster string default
unix_socket_group Connections and Authentication / Connection Settings Sets the owning group of the Unix-domain socket. The owning user of the socket is always the user that starts the server. postmaster string default
unix_socket_permissions 511 Connections and Authentication / Connection Settings Sets the access permissions of the Unix-domain socket. Unix-domain sockets use the usual Unix file system permission set. The parameter value is expected to be an numeric mode specification in the form accepted by the chmod and umask system calls. (To use the customary octal format the number must start with a 0 (zero).) postmaster integer default 0 511
authentication_timeout 60 s Connections and Authentication / Security and Authentication Sets the maximum allowed time to complete client authentication. sighup integer default 1 600
db_user_namespace off Connections and Authentication / Security and Authentication Enables per-database user names. sighup bool default
krb_caseins_users off Connections and Authentication / Security and Authentication Sets whether Kerberos and GSSAPI user names should be treated as case-insensitive. postmaster bool default
krb_realm Connections and Authentication / Security and Authentication Sets realm to match Kerberos and GSSAPI users against. postmaster string default
krb_server_hostname Connections and Authentication / Security and Authentication Sets the hostname of the Kerberos server. postmaster string default
krb_server_keyfile Connections and Authentication / Security and Authentication Sets the location of the Kerberos server key file. postmaster string default
krb_srvname postgres Connections and Authentication / Security and Authentication Sets the name of the Kerberos service. postmaster string default
password_encryption on Connections and Authentication / Security and Authentication Encrypt passwords. When a password is specified in CREATE USER or ALTER USER without writing either ENCRYPTED or UNENCRYPTED, this parameter determines whether the password is to be encrypted. user bool default
ssl off Connections and Authentication / Security and Authentication Enables SSL connections. postmaster bool default
custom_variable_classes Customized Options Sets the list of known custom variable classes. sighup string default
allow_system_table_mods off Developer Options Allows modifications of the structure of system tables. postmaster bool default
debug_assertions off Developer Options Turns on various assertion checks. This is a debugging aid. user bool default
ignore_system_indexes off Developer Options Disables reading from system indexes. It does not prevent updating the indexes, so it is safe to use. The worst consequence is slowness. backend bool default
post_auth_delay 0 s Developer Options Waits N seconds on connection startup after authentication. This allows attaching a debugger to the process. backend integer default 0 2147483647
pre_auth_delay 0 s Developer Options Waits N seconds on connection startup before authentication. This allows attaching a debugger to the process. sighup integer default 0 60
trace_notify off Developer Options Generates debugging output for LISTEN and NOTIFY. user bool default
trace_sort off Developer Options Emit information about resource usage in sorting. user bool default
zero_damaged_pages off Developer Options Continues processing past damaged page headers. Detection of a damaged page header normally causes PostgreSQL to report an error, aborting the current transaction. Setting zero_damaged_pages to true causes the system to instead report a warning, zero out the damaged page, and continue processing. This behavior will destroy data, namely all the rows on the damaged page. superuser bool default
config_file /opt/postgresql-8.3/data/postgresql.conf File Locations Sets the server's main configuration file. postmaster string override
data_directory /opt/postgresql-8.3/data File Locations Sets the server's data directory. postmaster string override
external_pid_file File Locations Writes the postmaster PID to the specified file. postmaster string default
hba_file /opt/postgresql-8.3/data/pg_hba.conf File Locations Sets the server's "hba" configuration file. postmaster string override
ident_file /opt/postgresql-8.3/data/pg_ident.conf File Locations Sets the server's "ident" configuration file. postmaster string override
deadlock_timeout 1000 ms Lock Management Sets the time to wait on a lock before checking for deadlock. sighup integer default 1 2147483
max_locks_per_transaction 64 Lock Management Sets the maximum number of locks per transaction. The shared lock table is sized on the assumption that at most max_locks_per_transaction * max_connections distinct objects will need to be locked at any one time. postmaster integer default 10 2147483647
block_size 8192 Preset Options Shows the size of a disk block. internal integer default 8192 8192
integer_datetimes off Preset Options Datetimes are integer based. internal bool default
max_function_args 100 Preset Options Shows the maximum number of function arguments. internal integer default 100 100
max_identifier_length 63 Preset Options Shows the maximum identifier length. internal integer default 63 63
max_index_keys 32 Preset Options Shows the maximum number of index keys. internal integer default 32 32
server_version 8.3.1 Preset Options Shows the server version. internal string default
server_version_num 80301 Preset Options Shows the server version as an integer. internal integer default 80301 80301
geqo on Query Tuning / Genetic Query Optimizer Enables genetic query optimization. This algorithm attempts to do planning without exhaustive searching. user bool default
geqo_effort 5 Query Tuning / Genetic Query Optimizer GEQO: effort is used to set the default for other GEQO parameters. user integer default 1 10
geqo_generations 0 Query Tuning / Genetic Query Optimizer GEQO: number of iterations of the algorithm. Zero selects a suitable default value. user integer default 0 2147483647
geqo_pool_size 0 Query Tuning / Genetic Query Optimizer GEQO: number of individuals in the population. Zero selects a suitable default value. user integer default 0 2147483647
geqo_selection_bias 2 Query Tuning / Genetic Query Optimizer GEQO: selective pressure within the population. user real default 1.5 2
geqo_threshold 12 Query Tuning / Genetic Query Optimizer Sets the threshold of FROM items beyond which GEQO is used. user integer default 2 2147483647
constraint_exclusion off Query Tuning / Other Planner Options Enables the planner to use constraints to optimize queries. Child table scans will be skipped if their constraints guarantee that no rows match the query. user bool default
default_statistics_target 10 Query Tuning / Other Planner Options Sets the default statistics target. This applies to table columns that have not had a column-specific target set via ALTER TABLE SET STATISTICS. user integer default 1 1000
from_collapse_limit 8 Query Tuning / Other Planner Options Sets the FROM-list size beyond which subqueries are not collapsed. The planner will merge subqueries into upper queries if the resulting FROM list would have no more than this many items. user integer default 1 2147483647
join_collapse_limit 8 Query Tuning / Other Planner Options Sets the FROM-list size beyond which JOIN constructs are not flattened. The planner will flatten explicit JOIN constructs into lists of FROM items whenever a list of no more than this many items would result. user integer default 1 2147483647
cpu_index_tuple_cost 0.005 Query Tuning / Planner Cost Constants Sets the planner's estimate of the cost of processing each index entry during an index scan. user real default 0 1.79769e+308
cpu_operator_cost 0.0025 Query Tuning / Planner Cost Constants Sets the planner's estimate of the cost of processing each operator or function call. user real default 0 1.79769e+308
cpu_tuple_cost 0.01 Query Tuning / Planner Cost Constants Sets the planner's estimate of the cost of processing each tuple (row). user real default 0 1.79769e+308
effective_cache_size 16384 8kB Query Tuning / Planner Cost Constants Sets the planner's assumption about the size of the disk cache. That is, the portion of the kernel's disk cache that will be used for PostgreSQL data files. This is measured in disk pages, which are normally 8 kB each. user integer default 1 2147483647
random_page_cost 4 Query Tuning / Planner Cost Constants Sets the planner's estimate of the cost of a nonsequentially fetched disk page. user real default 0 1.79769e+308
seq_page_cost 1 Query Tuning / Planner Cost Constants Sets the planner's estimate of the cost of a sequentially fetched disk page. user real default 0 1.79769e+308
enable_bitmapscan on Query Tuning / Planner Method Configuration Enables the planner's use of bitmap-scan plans. user bool default
enable_hashagg on Query Tuning / Planner Method Configuration Enables the planner's use of hashed aggregation plans. user bool default
enable_hashjoin on Query Tuning / Planner Method Configuration Enables the planner's use of hash join plans. user bool default
enable_indexscan on Query Tuning / Planner Method Configuration Enables the planner's use of index-scan plans. user bool default
enable_mergejoin on Query Tuning / Planner Method Configuration Enables the planner's use of merge join plans. user bool default
enable_nestloop on Query Tuning / Planner Method Configuration Enables the planner's use of nested-loop join plans. user bool default
enable_seqscan on Query Tuning / Planner Method Configuration Enables the planner's use of sequential-scan plans. user bool default
enable_sort on Query Tuning / Planner Method Configuration Enables the planner's use of explicit sort steps. user bool default
enable_tidscan on Query Tuning / Planner Method Configuration Enables the planner's use of TID scan plans. user bool default
debug_pretty_print off Reporting and Logging / What to Log Indents parse and plan tree displays. user bool default
debug_print_parse off Reporting and Logging / What to Log Prints the parse tree to the server log. user bool default
debug_print_plan off Reporting and Logging / What to Log Prints the execution plan to server log. user bool default
debug_print_rewritten off Reporting and Logging / What to Log Prints the parse tree after rewriting to server log. user bool default
log_autovacuum_min_duration -1 ms Reporting and Logging / What to Log Sets the minimum execution time above which autovacuum actions will be logged. Zero prints all actions. -1 turns autovacuum logging off. sighup integer default -1 2147483
log_checkpoints on Reporting and Logging / What to Log Logs each checkpoint. sighup bool configuration file
log_connections on Reporting and Logging / What to Log Logs each successful connection. backend bool configuration file
log_disconnections on Reporting and Logging / What to Log Logs end of a session, including duration. backend bool configuration file
log_duration off Reporting and Logging / What to Log Logs the duration of each completed SQL statement. superuser bool default
log_hostname off Reporting and Logging / What to Log Logs the host name in the connection logs. By default, connection logs only show the IP address of the connecting host. If you want them to show the host name you can turn this on, but depending on your host name resolution setup it might impose a non-negligible performance penalty. sighup bool default
log_line_prefix Reporting and Logging / What to Log Controls information prefixed to each log line. If blank, no prefix is used. sighup string default
log_lock_waits on Reporting and Logging / What to Log Logs long lock waits. superuser bool configuration file
log_statement all Reporting and Logging / What to Log Sets the type of statements logged. Valid values are "none", "ddl", "mod", and "all". superuser string configuration file
log_temp_files -1 kB Reporting and Logging / What to Log Log the use of temporary files larger than this number of kilobytes. Zero logs all files. The default is -1 (turning this feature off). user integer default -1 2147483647
log_timezone Europe/Paris Reporting and Logging / What to Log Sets the time zone to use in log messages. sighup string command line
client_min_messages notice Reporting and Logging / When to Log Sets the message levels that are sent to the client. Valid values are DEBUG5, DEBUG4, DEBUG3, DEBUG2, DEBUG1, LOG, NOTICE, WARNING, and ERROR. Each level includes all the levels that follow it. The later the level, the fewer messages are sent. user string default
log_error_verbosity verbose Reporting and Logging / When to Log Sets the verbosity of logged messages. Valid values are "terse", "default", and "verbose". superuser string configuration file
log_min_duration_statement 250 ms Reporting and Logging / When to Log Sets the minimum execution time above which statements will be logged. Zero prints all queries. -1 turns this feature off. superuser integer configuration file -1 2147483
log_min_error_statement error Reporting and Logging / When to Log Causes all statements generating error at or above this level to be logged. All SQL statements that cause an error of the specified level or a higher level are logged. superuser string default
log_min_messages notice Reporting and Logging / When to Log Sets the message levels that are logged. Valid values are DEBUG5, DEBUG4, DEBUG3, DEBUG2, DEBUG1, INFO, NOTICE, WARNING, ERROR, LOG, FATAL, and PANIC. Each level includes all the levels that follow it. superuser string default
silent_mode off Reporting and Logging / When to Log Runs the server silently. If this parameter is set, the server will automatically run in the background and any controlling terminals are dissociated. postmaster bool default
log_destination csvlog Reporting and Logging / Where to Log Sets the destination for server log output. Valid values are combinations of "stderr", "syslog", "csvlog", and "eventlog", depending on the platform. sighup string configuration file
log_directory pg_log Reporting and Logging / Where to Log Sets the destination directory for log files. Can be specified as relative to the data directory or as absolute path. sighup string default
log_filename postgresql-%Y-%m-%d_%H%M%S.log Reporting and Logging / Where to Log Sets the file name pattern for log files. sighup string default
logging_collector on Reporting and Logging / Where to Log Start a subprocess to capture stderr output and/or csvlogs into log files. postmaster bool configuration file
log_rotation_age 1440 min Reporting and Logging / Where to Log Automatic log file rotation will occur after N minutes. sighup integer default 0 35791394
log_rotation_size 10240 kB Reporting and Logging / Where to Log Automatic log file rotation will occur after N kilobytes. sighup integer default 0 2097151
log_truncate_on_rotation off Reporting and Logging / Where to Log Truncate existing log files of same name during log rotation. sighup bool default
syslog_facility LOCAL0 Reporting and Logging / Where to Log Sets the syslog "facility" to be used when syslog enabled. Valid values are LOCAL0, LOCAL1, LOCAL2, LOCAL3, LOCAL4, LOCAL5, LOCAL6, LOCAL7. sighup string default
syslog_ident postgres Reporting and Logging / Where to Log Sets the program name used to identify PostgreSQL messages in syslog. sighup string default
bgwriter_delay 200 ms Resource Usage Background writer sleep time between rounds. sighup integer default 10 10000
bgwriter_lru_maxpages 100 Resource Usage Background writer maximum number of LRU pages to flush per round. sighup integer default 0 1000
bgwriter_lru_multiplier 2 Resource Usage Background writer multiplier on average buffers to scan per round. sighup real default 0 10
max_prepared_transactions 5 Resource Usage Sets the maximum number of simultaneously prepared transactions. postmaster integer default 0 2147483647
vacuum_cost_delay 0 ms Resource Usage Vacuum cost delay in milliseconds. user integer default 0 1000
vacuum_cost_limit 200 Resource Usage Vacuum cost amount available before napping. user integer default 1 10000
vacuum_cost_page_dirty 20 Resource Usage Vacuum cost for a page dirtied by vacuum. user integer default 0 10000
vacuum_cost_page_hit 1 Resource Usage Vacuum cost for a page found in the buffer cache. user integer default 0 10000
vacuum_cost_page_miss 10 Resource Usage Vacuum cost for a page not found in the buffer cache. user integer default 0 10000
max_fsm_pages 153600 Resource Usage / Free Space Map Sets the maximum number of disk pages for which free space is tracked. postmaster integer configuration file 1000 2147483647
max_fsm_relations 1000 Resource Usage / Free Space Map Sets the maximum number of tables and indexes for which free space is tracked. postmaster integer default 100 2147483647
max_files_per_process 1000 Resource Usage / Kernel Resources Sets the maximum number of simultaneously open files for each server process. postmaster integer default 25 2147483647
shared_preload_libraries Resource Usage / Kernel Resources Lists shared libraries to preload into server. postmaster string default
maintenance_work_mem 16384 kB Resource Usage / Memory Sets the maximum memory to be used for maintenance operations. This includes operations such as VACUUM and CREATE INDEX. user integer default 1024 2097151
max_stack_depth 2048 kB Resource Usage / Memory Sets the maximum stack depth, in kilobytes. superuser integer environment variable 100 2097151
shared_buffers 3072 8kB Resource Usage / Memory Sets the number of shared memory buffers used by the server. postmaster integer configuration file 16 1073741823
temp_buffers 1024 8kB Resource Usage / Memory Sets the maximum number of temporary buffers used by each session. user integer default 100 1073741823
work_mem 1024 kB Resource Usage / Memory Sets the maximum memory to be used for query workspaces. This much memory can be used by each internal sort operation and hash table before switching to temporary disk files. user integer default 64 2097151
log_executor_stats off Statistics / Monitoring Writes executor performance statistics to the server log. superuser bool default
log_parser_stats off Statistics / Monitoring Writes parser performance statistics to the server log. superuser bool default
log_planner_stats off Statistics / Monitoring Writes planner performance statistics to the server log. superuser bool default
log_statement_stats off Statistics / Monitoring Writes cumulative performance statistics to the server log. superuser bool default
track_activities on Statistics / Query and Index Statistics Collector Collects information about executing commands. Enables the collection of information on the currently executing command of each session, along with the time at which that command began execution. superuser bool default
track_counts on Statistics / Query and Index Statistics Collector Collects statistics on database activity. superuser bool default
update_process_title on Statistics / Query and Index Statistics Collector Updates the process title to show the active SQL command. Enables updating of the process title every time a new SQL command is received by the server. superuser bool default
transform_null_equals off Version and Platform Compatibility / Other Platforms and Clients Treats "expr=NULL" as "expr IS NULL". When turned on, expressions of the form expr = NULL (or NULL = expr) are treated as expr IS NULL, that is, they return true if expr evaluates to the null value, and false otherwise. The correct behavior of expr = NULL is to always return null (unknown). user bool default
add_missing_from off Version and Platform Compatibility / Previous PostgreSQL Versions Automatically adds missing table references to FROM clauses. user bool default
array_nulls on Version and Platform Compatibility / Previous PostgreSQL Versions Enable input of NULL elements in arrays. When turned on, unquoted NULL in an array input value means a null value; otherwise it is taken literally. user bool default
backslash_quote safe_encoding Version and Platform Compatibility / Previous PostgreSQL Versions Sets whether "\'" is allowed in string literals. Valid values are ON, OFF, and SAFE_ENCODING. user string default
default_with_oids off Version and Platform Compatibility / Previous PostgreSQL Versions Create new tables with OIDs by default. user bool default
escape_string_warning on Version and Platform Compatibility / Previous PostgreSQL Versions Warn about backslash escapes in ordinary string literals. user bool default
regex_flavor advanced Version and Platform Compatibility / Previous PostgreSQL Versions Sets the regular expression "flavor". This can be set to advanced, extended, or basic. user string default
sql_inheritance on Version and Platform Compatibility / Previous PostgreSQL Versions Causes subtables to be included by default in various commands. user bool default
standard_conforming_strings off Version and Platform Compatibility / Previous PostgreSQL Versions Causes '...' strings to treat backslashes literally. user bool default
synchronize_seqscans on Version and Platform Compatibility / Previous PostgreSQL Versions Enable synchronized sequential scans. user bool default
checkpoint_completion_target 0.5 Write-Ahead Log / Checkpoints Time spent flushing dirty buffers during checkpoint, as fraction of checkpoint interval. sighup real default 0 1
checkpoint_segments 3 Write-Ahead Log / Checkpoints Sets the maximum distance in log segments between automatic WAL checkpoints. sighup integer default 1 2147483647
checkpoint_timeout 300 s Write-Ahead Log / Checkpoints Sets the maximum time between automatic WAL checkpoints. sighup integer default 30 3600
checkpoint_warning 30 s Write-Ahead Log / Checkpoints Enables warnings if checkpoint segments are filled more frequently than this. Write a message to the server log if checkpoints caused by the filling of checkpoint segment files happens more frequently than this number of seconds. Zero turns off the warning. sighup integer default 0 2147483647
archive_command (disabled) Write-Ahead Log / Settings Sets the shell command that will be called to archive a WAL file. sighup string default
archive_mode off Write-Ahead Log / Settings Allows archiving of WAL files using archive_command. postmaster bool default
archive_timeout 0 s Write-Ahead Log / Settings Forces a switch to the next xlog file if a new file has not been started within N seconds. sighup integer default 0 2147483647
commit_delay 0 Write-Ahead Log / Settings Sets the delay in microseconds between transaction commit and flushing WAL to disk. user integer default 0 100000
commit_siblings 5 Write-Ahead Log / Settings Sets the minimum concurrent open transactions before performing commit_delay. user integer default 1 1000
fsync on Write-Ahead Log / Settings Forces synchronization of updates to disk. The server will use the fsync() system call in several places to make sure that updates are physically written to disk. This insures that a database cluster will recover to a consistent state after an operating system or hardware crash. sighup bool default
full_page_writes on Write-Ahead Log / Settings Writes full pages to WAL when first modified after a checkpoint. A page write in process during an operating system crash might be only partially written to disk. During recovery, the row changes stored in WAL are not enough to recover. This option writes pages when first modified after a checkpoint to WAL so full recovery is possible. sighup bool default
synchronous_commit on Write-Ahead Log / Settings Sets immediate fsync at commit. user bool default
wal_buffers 8 8kB Write-Ahead Log / Settings Sets the number of disk-page buffers in shared memory for WAL. postmaster integer default 4 2147483647
wal_sync_method fdatasync Write-Ahead Log / Settings Selects the method used for forcing WAL updates to disk. sighup string default
wal_writer_delay 200 ms Write-Ahead Log / Settings WAL writer sleep time between WAL flushes. sighup integer default 1 10000

SELECT name, setting, unit, category, short_desc, extra_desc, context, vartype, source, min_val, max_val FROM pg_settings ORDER BY category, name