Description
my postgres version is 12.1:
Type your choice and press :
t1
psql:/home/pg121/postgres_dba/sql/t1_tuning.sql:7: error: unrecognized value ":postgres_dba_interactive_mode" for "\if expression": Boolean expected
Parameter | Value | Default | Category
---------------------------------+---------+---------+------------------------------------------------------
autovacuum_analyze_scale_factor | 0.1 | 0.1 | Autovacuum
autovacuum_max_workers | 3 | 3 | Autovacuum
autovacuum_naptime | 60 | 60 | Autovacuum
autovacuum_vacuum_scale_factor | 0.2 | 0.2 | Autovacuum
max_connections | 100 | 100 | Connections and Authentication / Connection Settings
default_statistics_target | 100 | 100 | Query Tuning / Other Planner Options
effective_cache_size | 4096 MB | 4096 MB | Query Tuning / Planner Cost Constants
random_page_cost | 4 | 4 | Query Tuning / Planner Cost Constants
seq_page_cost | 1 | 1 | Query Tuning / Planner Cost Constants
effective_io_concurrency | 1 | 1 | Resource Usage / Asynchronous Behavior
max_parallel_workers | 8 | 8 | Resource Usage / Asynchronous Behavior
max_parallel_workers_per_gather | 2 | 2 | Resource Usage / Asynchronous Behavior
max_worker_processes | 8 | 8 | Resource Usage / Asynchronous Behavior
autovacuum_work_mem | -1 | -1 | Resource Usage / Memory
maintenance_work_mem | 64 MB | 64 MB | Resource Usage / Memory
shared_buffers | 128 MB | 8192 kB | Resource Usage / Memory
work_mem | 4096 kB | 4096 kB | Resource Usage / Memory
checkpoint_completion_target | 0.5 | 0.5 | Write-Ahead Log / Checkpoints
max_wal_size | 1024 | 1024 | Write-Ahead Log / Checkpoints
min_wal_size | 80 | 80 | Write-Ahead Log / Checkpoints
wal_buffers | 4096 kB | -1 | Write-Ahead Log / Settings
(21 rows)
Press to continue…