archive_cleanup_command |
Write-Ahead Log / Archive Recovery |
Sets the shell command that will be executed at every restart point. |
|
string |
None |
|
autovacuum_vacuum_insert_scale_factor |
Autovacuum |
Number of tuple inserts prior to vacuum as a fraction of reltuples. |
0.2 |
real |
None |
|
autovacuum_vacuum_insert_threshold |
Autovacuum |
Minimum number of tuple inserts prior to vacuum, or -1 to disable insert vacuums. |
1000 |
integer |
None |
|
backtrace_functions |
Developer Options |
Log backtrace for errors in these functions. |
|
string |
None |
|
default_table_access_method |
Client Connection Defaults / Statement Behavior |
Sets the default table access method for new tables. |
heap |
string |
None |
|
enable_incremental_sort |
Query Tuning / Planner Method Configuration |
Enables the planner's use of incremental sort steps. |
on |
bool |
None |
|
hash_mem_multiplier |
Resource Usage / Memory |
Multiple of work_mem to use for hash tables. |
1 |
real |
None |
|
ignore_invalid_pages |
Developer Options |
Continues recovery after an invalid pages failure. |
off |
bool |
None |
|
log_min_duration_sample |
Reporting and Logging / When to Log |
Sets the minimum execution time above which a sample of statements will be logged. Sampling is determined by log_statement_sample_rate. |
-1 ms |
integer |
None |
|
log_parameter_max_length |
Reporting and Logging / What to Log |
When logging statements, limit logged parameter values to first N bytes. |
-1 B |
integer |
None |
|
log_parameter_max_length_on_error |
Reporting and Logging / What to Log |
When reporting an error, limit logged parameter values to first N bytes. |
0 B |
integer |
None |
|
log_statement_sample_rate |
Reporting and Logging / When to Log |
Fraction of statements exceeding log_min_duration_sample to be logged. |
1 |
real |
None |
|
log_transaction_sample_rate |
Reporting and Logging / When to Log |
Set the fraction of transactions to log for new transactions. |
0 |
real |
None |
|
logical_decoding_work_mem |
Resource Usage / Memory |
Sets the maximum memory to be used for logical decoding. |
65536 kB |
integer |
None |
|
maintenance_io_concurrency |
Resource Usage / Asynchronous Behavior |
A variant of effective_io_concurrency that is used for maintenance work. |
10 |
integer |
None |
|
max_slot_wal_keep_size |
Replication / Sending Servers |
Sets the maximum WAL size that can be reserved by replication slots. |
-1 MB |
integer |
None |
|
pg_stat_statements.track_planning |
Customized Options |
Selects whether planning duration is tracked by pg_stat_statements. |
off |
bool |
None |
|
plan_cache_mode |
Query Tuning / Other Planner Options |
Controls the planner's selection of custom or generic plan. |
auto |
enum |
[auto, force_generic_plan, force_custom_plan] |
|
primary_conninfo |
Replication / Standby Servers |
Sets the connection string to be used to connect to the sending server. |
|
string |
None |
|
primary_slot_name |
Replication / Standby Servers |
Sets the name of the replication slot to use on the sending server. |
|
string |
None |
|
promote_trigger_file |
Replication / Standby Servers |
Specifies a file name whose presence ends recovery in the standby. |
|
string |
None |
|
recovery_end_command |
Write-Ahead Log / Archive Recovery |
Sets the shell command that will be executed once at the end of recovery. |
|
string |
None |
|
recovery_min_apply_delay |
Replication / Standby Servers |
Sets the minimum delay for applying changes during recovery. |
0 ms |
integer |
None |
|
recovery_target |
Write-Ahead Log / Recovery Target |
Set to "immediate" to end recovery as soon as a consistent state is reached. |
|
string |
None |
|
recovery_target_action |
Write-Ahead Log / Recovery Target |
Sets the action to perform upon reaching the recovery target. |
pause |
enum |
[pause, promote, shutdown] |
|
recovery_target_inclusive |
Write-Ahead Log / Recovery Target |
Sets whether to include or exclude transaction with recovery target. |
on |
bool |
None |
|
recovery_target_lsn |
Write-Ahead Log / Recovery Target |
Sets the LSN of the write-ahead log location up to which recovery will proceed. |
|
string |
None |
|
recovery_target_name |
Write-Ahead Log / Recovery Target |
Sets the named restore point up to which recovery will proceed. |
|
string |
None |
|
recovery_target_time |
Write-Ahead Log / Recovery Target |
Sets the time stamp up to which recovery will proceed. |
|
string |
None |
|
recovery_target_timeline |
Write-Ahead Log / Recovery Target |
Specifies the timeline to recover into. |
latest |
string |
None |
|
recovery_target_xid |
Write-Ahead Log / Recovery Target |
Sets the transaction ID up to which recovery will proceed. |
|
string |
None |
|
restore_command |
Write-Ahead Log / Archive Recovery |
Sets the shell command that will be called to retrieve an archived WAL file. |
|
string |
None |
|
shared_memory_type |
Resource Usage / Memory |
Selects the shared memory implementation used for the main shared memory region. |
mmap |
enum |
[sysv, mmap] |
|
ssl_max_protocol_version |
Connections and Authentication / SSL |
Sets the maximum SSL/TLS protocol version to use. |
|
enum |
[, TLSv1, TLSv1.1, TLSv1.2, TLSv1.3] |
|
ssl_min_protocol_version |
Connections and Authentication / SSL |
Sets the minimum SSL/TLS protocol version to use. |
TLSv1.2 |
enum |
[TLSv1, TLSv1.1, TLSv1.2, TLSv1.3] |
|
tcp_user_timeout |
Client Connection Defaults / Other Defaults |
TCP user timeout. |
0 ms |
integer |
None |
|
wal_init_zero |
Write-Ahead Log / Settings |
Writes zeroes to new WAL files before first use. |
on |
bool |
None |
|
wal_keep_size |
Replication / Sending Servers |
Sets the size of WAL files held for standby servers. |
0 MB |
integer |
None |
|
wal_receiver_create_temp_slot |
Replication / Standby Servers |
Sets whether a WAL receiver should create a temporary replication slot if no permanent slot is configured. |
off |
bool |
None |
|
wal_recycle |
Write-Ahead Log / Settings |
Recycles WAL files by renaming them. |
on |
bool |
None |
|
wal_skip_threshold |
Write-Ahead Log / Settings |
Size of new file to fsync instead of writing WAL. |
2048 kB |
integer |
None |
|