Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

Appears to suggest default settings #90

Open
lnicola opened this issue Nov 12, 2021 · 0 comments
Open

Appears to suggest default settings #90

lnicola opened this issue Nov 12, 2021 · 0 comments

Comments

@lnicola
Copy link

lnicola commented Nov 12, 2021

Using postgresql.conf at this path:
/etc/postgresql/14/main/postgresql.conf

Is this correct? [(y)es/(n)o]: y
Writing backup to:
/tmp/timescaledb_tune.backup202111120906

success: shared_preload_libraries is set correctly

Tune memory/parallelism/WAL and other settings? [(y)es/(n)o]: y
Recommendations based on 3.74 GB of available memory and 3 CPUs for PostgreSQL 14

Memory settings recommendations
success: memory settings are already tuned

Parallelism settings recommendations
Current:
#max_parallel_workers_per_gather = 2
Recommended:
max_parallel_workers_per_gather = 2
Is this okay? [(y)es/(s)kip/(q)uit]: s
warning: parallelism settings left alone, but still need tuning

WAL settings recommendations
success: WAL settings are already tuned

Miscellaneous settings recommendations
Current:
#checkpoint_completion_target = 0.9
#max_locks_per_transaction = 64
Recommended:
checkpoint_completion_target = 0.9
max_locks_per_transaction = 64
Is this okay? [(y)es/(s)kip/(q)uit]: s
warning: miscellaneous settings left alone, but still need tuning
Saving changes to: /etc/postgresql/14/main/postgresql.conf

timescaledb-tune 0.12.0 (linux amd64)
# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant