search

NikolayS / postgres_dba

The missing set of useful tools for Postgres DBAs and all engineers
BSD 3-Clause "New" or "Revised" License
1.12k stars 116 forks source link

t1 has one error,why? #47

Open msdnchina opened 4 years ago

msdnchina commented 4 years ago

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…

NikolayS commented 4 years ago

Uh, it was my attempt to have both good CI tests (running in a non-interactive mode) and the main, interactive mode for humans.

An unfinished attempt – t1 doesn't offer any recommendations, the work is unfinished. It only shows the main performance configuration params, and then you can use something like https://pgtune.leopard.in.ua/ to perform tuning (very, very basic, of course).

I'm thinking about what to do with it, thanks for the bug report @msdnchina! Somehow this error is not easy to notice.

To get rid of it right now, please add this to ~/.psqlrc:

\set postgres_dba_interactive_mode false