There are several WAL -related configuration parameters that affect database performance. This section explains their use. Consult Chapter 18 for general information about setting server configuration …

wal_level is a configuration parameter determining the level of detail written to WAL. wal_level was added in PostgreSQL 9.0. The default value for wal_level is: wal_level can only be changed by a …

Jul 13, 2025 · SQL Functions with Default Values for Arguments # Functions can be declared with listed in default values for some or all input arguments. The default values are inserted

To use PostgreSQL replication it is necessary to change the wal_level from “minimal” to “hot_standby”. But, which impact does this change have on the amount of WAL actually written to disk? And which …

Apr 10, 2018 · wal_level controls how much information is written into the write-ahead log. Higher settings write more information, enabling more features, at the expense of (somewhat) larger write …

Nov 13, 2025 · If archive_command is an empty string (the default) while archive_mode is enabled (and archive_library is set to an empty string), WAL archiving is temporarily disabled, but the server …

Nov 13, 2025 · Briefly, WAL 's central concept is that changes to data files (where tables and indexes reside) must be written only after those changes have been logged, that is, after WAL records …

Nov 13, 2025 · Specifies the maximum number of concurrent connections from standby servers or streaming base backup clients (i.e., the maximum number of simultaneously running WAL sender …

Jan 27, 2015 · Unfortunately, at least as of 2013, per a discussion on a PostgreSQL mailing list, setting wal_keep_segments to a nonzero value may still be recommended - this is to prevent risking the …

Postgres Parameter across Versions Select a parameter to view the defaults across versions of PostgreSQL.