Tune it with confidence

archive_command — PostgreSQL Configuration Parameter

Shell command to archive a completed WAL file.

archive_mode — PostgreSQL Configuration Parameter

Enable WAL archiving for PITR/standbys.

maintenance_io_concurrency — PostgreSQL Configuration Parameter

Prefetch concurrency for maintenance operations.

password_encryption — PostgreSQL Configuration Parameter

Hashing algorithm used when storing passwords.

ssl — PostgreSQL Configuration Parameter

Enables SSL/TLS connections.

ssl_min_protocol_version — PostgreSQL Configuration Parameter

Minimum TLS protocol version accepted.

autovacuum — PostgreSQL Configuration Parameter

Master switch for the autovacuum daemon.

autovacuum_freeze_max_age — PostgreSQL Configuration Parameter

Table age that forces an anti-wraparound autovacuum.

autovacuum_max_workers — PostgreSQL Configuration Parameter

Maximum concurrent autovacuum worker processes.

autovacuum_naptime — PostgreSQL Configuration Parameter

Delay between autovacuum runs per database.

autovacuum_vacuum_cost_delay — PostgreSQL Configuration Parameter

Throttling pause for autovacuum I/O.

autovacuum_vacuum_cost_limit — PostgreSQL Configuration Parameter

I/O cost budget before autovacuum sleeps (-1 = use vacuum_cost_limit).

autovacuum_vacuum_insert_scale_factor — PostgreSQL Configuration Parameter

Insert-driven autovacuum threshold fraction (PG13+).

autovacuum_vacuum_scale_factor — PostgreSQL Configuration Parameter

Fraction of table that must be dead before autovacuum runs.

autovacuum_vacuum_threshold — PostgreSQL Configuration Parameter

Minimum dead tuples before autovacuum considers a table.

bgwriter_delay — PostgreSQL Configuration Parameter

Sleep between background-writer rounds.

bgwriter_lru_maxpages — PostgreSQL Configuration Parameter

Max buffers the background writer flushes per round.

checkpoint_completion_target — PostgreSQL Configuration Parameter

Fraction of the interval over which to spread checkpoint writes.

checkpoint_timeout — PostgreSQL Configuration Parameter

Maximum time between automatic checkpoints.

max_wal_size — PostgreSQL Configuration Parameter

Soft upper limit of WAL between automatic checkpoints.

min_wal_size — PostgreSQL Configuration Parameter

WAL kept and recycled rather than removed.

client_encoding — PostgreSQL Configuration Parameter

Character set used for client communication.

default_transaction_isolation — PostgreSQL Configuration Parameter

Default isolation level for new transactions.

default_transaction_read_only — PostgreSQL Configuration Parameter

Make new transactions read-only by default.

idle_in_transaction_session_timeout — PostgreSQL Configuration Parameter

Terminate sessions idle inside an open transaction.

idle_session_timeout — PostgreSQL Configuration Parameter

Terminate sessions idle outside any transaction (PG14+).

lock_timeout — PostgreSQL Configuration Parameter

Abort a statement waiting too long for a lock.

search_path — PostgreSQL Configuration Parameter

Schema search order for unqualified names.

statement_timeout — PostgreSQL Configuration Parameter

Abort any statement running longer than this.

timezone — PostgreSQL Configuration Parameter

Time zone for displaying and interpreting timestamps.

authentication_timeout — PostgreSQL Configuration Parameter

Maximum time to complete client authentication.

listen_addresses — PostgreSQL Configuration Parameter

TCP/IP addresses the server listens on.

max_connections — PostgreSQL Configuration Parameter

Maximum number of concurrent client connections.

port — PostgreSQL Configuration Parameter

TCP port the server listens on.

reserved_connections — PostgreSQL Configuration Parameter

Slots reserved for roles with the RESERVED_CONNECTION privilege (PG16+).

superuser_reserved_connections — PostgreSQL Configuration Parameter

Connection slots reserved for superusers.

tcp_keepalives_idle — PostgreSQL Configuration Parameter

Idle time before TCP keepalive probes start.

unix_socket_directories — PostgreSQL Configuration Parameter

Directories for Unix-domain socket files.

data_sync_retry — PostgreSQL Configuration Parameter

Whether to retry after an fsync failure instead of panicking.

restart_after_crash — PostgreSQL Configuration Parameter

Automatically restart after a backend crash.

deadlock_timeout — PostgreSQL Configuration Parameter

Wait before checking for a deadlock.

max_locks_per_transaction — PostgreSQL Configuration Parameter

Average lock slots reserved per transaction.

max_pred_locks_per_transaction — PostgreSQL Configuration Parameter

Predicate-lock table sizing for SERIALIZABLE.

log_autovacuum_min_duration — PostgreSQL Configuration Parameter

Log autovacuum actions that run at least this long.

log_checkpoints — PostgreSQL Configuration Parameter

Log each checkpoint with timing and buffer stats.

log_line_prefix — PostgreSQL Configuration Parameter

Printf-style prefix on each log line.

log_lock_waits — PostgreSQL Configuration Parameter

Log sessions that wait longer than deadlock_timeout for a lock.

log_min_duration_statement — PostgreSQL Configuration Parameter

Log statements running at least this long.

log_statement — PostgreSQL Configuration Parameter

Which statement kinds to log (none/ddl/mod/all).

log_temp_files — PostgreSQL Configuration Parameter

Log temporary files at least this large.

logging_collector — PostgreSQL Configuration Parameter

Capture stderr into managed, rotated log files.

autovacuum_work_mem — PostgreSQL Configuration Parameter

Memory each autovacuum worker may use (-1 = use maintenance_work_mem).

hash_mem_multiplier — PostgreSQL Configuration Parameter

Multiplier applied to work_mem for hash-based operations.

huge_pages — PostgreSQL Configuration Parameter

Use OS huge pages for shared memory.

maintenance_work_mem — PostgreSQL Configuration Parameter

Memory for maintenance operations (VACUUM, CREATE INDEX).

max_prepared_transactions — PostgreSQL Configuration Parameter

Max simultaneous two-phase-commit prepared transactions.

shared_buffers — PostgreSQL Configuration Parameter

Shared memory used for the buffer cache.

temp_buffers — PostgreSQL Configuration Parameter

Per-session memory for temporary tables.

work_mem — PostgreSQL Configuration Parameter

Memory per sort/hash operation before spilling to disk.

max_parallel_workers — PostgreSQL Configuration Parameter

Total parallel workers available cluster-wide.

max_parallel_workers_per_gather — PostgreSQL Configuration Parameter

Max parallel workers a single Gather node can use.

max_worker_processes — PostgreSQL Configuration Parameter

Total background worker processes the cluster can run.

shared_preload_libraries — PostgreSQL Configuration Parameter

Libraries loaded at server start (extensions, hooks).

default_statistics_target — PostgreSQL Configuration Parameter

Default sampling detail for ANALYZE statistics.

effective_cache_size — PostgreSQL Configuration Parameter

Planner's estimate of total cache available (OS + shared_buffers).

effective_io_concurrency — PostgreSQL Configuration Parameter

Number of concurrent I/O requests the planner assumes (prefetch).

jit — PostgreSQL Configuration Parameter

Enable Just-In-Time compilation of expressions.

join_collapse_limit — PostgreSQL Configuration Parameter

Max FROM items before the planner stops reordering joins.

random_page_cost — PostgreSQL Configuration Parameter

Planner cost of a non-sequential page fetch.

seq_page_cost — PostgreSQL Configuration Parameter

Planner cost of a sequential page fetch (the baseline).

hot_standby — PostgreSQL Configuration Parameter

Allow read-only queries on a standby during recovery.

hot_standby_feedback — PostgreSQL Configuration Parameter

Standby tells primary about its oldest snapshot to avoid query conflicts.

max_replication_slots — PostgreSQL Configuration Parameter

Max replication slots (physical + logical).

max_standby_streaming_delay — PostgreSQL Configuration Parameter

How long replay waits before canceling a conflicting standby query.

max_wal_senders — PostgreSQL Configuration Parameter

Max concurrent WAL sender processes (standbys + base backups).

primary_conninfo — PostgreSQL Configuration Parameter

Connection string a standby uses to stream from the primary.

synchronous_standby_names — PostgreSQL Configuration Parameter

Standbys that must confirm commits (synchronous replication).

wal_keep_size — PostgreSQL Configuration Parameter

Minimum WAL retained for standbys (replaces wal_keep_segments).

max_files_per_process — PostgreSQL Configuration Parameter

Max open files per server process.

compute_query_id — PostgreSQL Configuration Parameter

Compute a stable query identifier (PG14+).

track_activities — PostgreSQL Configuration Parameter

Track the current command of each session.

track_io_timing — PostgreSQL Configuration Parameter

Collect timing of block read/write operations.

fsync — PostgreSQL Configuration Parameter

Force WAL/data changes to durable storage.

full_page_writes — PostgreSQL Configuration Parameter

Write full page images after a checkpoint to survive torn pages.

synchronous_commit — PostgreSQL Configuration Parameter

When COMMIT waits for WAL durability / standby confirmation.

wal_buffers — PostgreSQL Configuration Parameter

Shared memory for unwritten WAL.

wal_compression — PostgreSQL Configuration Parameter

Compress full-page images written to WAL.

wal_level — PostgreSQL Configuration Parameter

Amount of information written to the WAL.