autovacuum_analyze_scale_factor |
Float |
Accepted values: 0 - 1 |
[optional] |
autovacuum_analyze_threshold |
Integer |
Accepted values: 0 - 2147483647 |
[optional] |
autovacuum_freeze_max_age |
Integer |
Accepted values: 200000000 - 1500000000 |
[optional] |
autovacuum_max_workers |
Integer |
Accepted values: 1 - 20 |
[optional] |
autovacuum_naptime |
Integer |
Accepted values: 1 - 86400 |
[optional] |
autovacuum_vacuum_cost_delay |
Integer |
Accepted values: -1 - 100 |
[optional] |
autovacuum_vacuum_cost_limit |
Integer |
Accepted values: -1 - 10000 |
[optional] |
autovacuum_vacuum_scale_factor |
Float |
Accepted values: 0 - 1 |
[optional] |
autovacuum_vacuum_threshold |
Integer |
Accepted values: 0 - 2147483647 |
[optional] |
bgwriter_delay |
Integer |
Accepted values: 10 - 10000 |
[optional] |
bgwriter_flush_after |
Integer |
Accepted values: 0 - 2048 |
[optional] |
bgwriter_lru_maxpages |
Integer |
Accepted values: 0 - 1073741823 |
[optional] |
bgwriter_lru_multiplier |
Float |
Accepted values: 0 - 10 |
[optional] |
deadlock_timeout |
Integer |
Accepted values: 500 - 1800000 |
[optional] |
default_toast_compression |
Enum |
Accepted values: * `lz4` * `pglz` |
[optional] |
idle_in_transaction_session_timeout |
Integer |
Accepted values: 0 - 604800000 |
[optional] |
jit |
Boolean |
Accepted values: * `true` * `false` |
[optional] |
log_autovacuum_min_duration |
Integer |
Accepted values: -1 - 2147483647 |
[optional] |
log_error_verbosity |
Enum |
Accepted values: * `TERSE` * `DEFAULT` * `VERBOSE` |
[optional] |
log_line_prefix |
Enum |
Accepted values: * `'pid=%p,user=%u,db=%d,app=%a,client=%h '` * `'%t [%p]: [%l-1] user=%u,db=%d,app=%a,client=%h '` * `'%m [%p] %q[user=%u,db=%d,app=%a] '` |
[optional] |
log_min_duration_statement |
Integer |
Accepted values: -1 - 86400000 |
[optional] |
max_files_per_process |
Integer |
Accepted values: 1000 - 4096 |
[optional] |
max_locks_per_transaction |
Integer |
Accepted values: 64 - 6400 |
[optional] |
max_logical_replication_workers |
Integer |
Accepted values: 4 - 64 |
[optional] |
max_parallel_workers |
Integer |
Accepted values: 0 - 96 |
[optional] |
max_parallel_workers_per_gather |
Integer |
Accepted values: 0 - 96 |
[optional] |
max_pred_locks_per_transaction |
Integer |
Accepted values: 64 - 5120 |
[optional] |
max_prepared_transactions |
Integer |
Accepted values: 0 - 10000 |
[optional] |
max_replication_slots |
Integer |
Accepted values: 8 - 64 |
[optional] |
max_stack_depth |
Integer |
Accepted values: 2097152 - 6291456 |
[optional] |
max_standby_archive_delay |
Integer |
Accepted values: 1 - 43200000 |
[optional] |
max_standby_streaming_delay |
Integer |
Accepted values: 1 - 43200000 |
[optional] |
max_wal_senders |
Integer |
Accepted values: 20 - 64 |
[optional] |
max_worker_processes |
Integer |
Accepted values: 8 - 96 |
[optional] |
pg_partman_bgw_interval |
Integer |
Accepted values: 3600 - 604800 |
[optional] |
pg_partman_bgw_role |
String |
Maximum length: 64 characters |
[optional] |
pg_stat_statements_track |
Enum |
Accepted values: * `all` * `top` * `none` |
[optional] |
temp_file_limit |
Integer |
Accepted values: -1 - 2147483647 |
[optional] |
track_activity_query_size |
Integer |
Accepted values: 1024 - 10240 |
[optional] |
track_commit_timestamp |
Enum |
Accepted values: * `off` * `on` |
[optional] |
track_functions |
Enum |
Accepted values: * `all` * `pl` * `none` |
[optional] |
track_io_timing |
Enum |
Accepted values: * `off` * `on` |
[optional] |
wal_sender_timeout |
Integer |
Accepted values: 0, 5000 - 10800000 |
[optional] |
wal_writer_delay |
Integer |
Accepted values: 10 - 200 |
[optional] |