timescaledb-tune --yes

From wikieduonline
Jump to navigation Jump to search

timescaledb-tune --yes

Examples[edit]

timescaledb-tune --yes
Using postgresql.conf at this path:
/etc/postgresql/14/main/postgresql.conf

Writing backup to:
/tmp/timescaledb_tune.backup202302021532

success: shared_preload_libraries is set correctly

Recommendations based on 3.77 GB of available memory and 2 CPUs for PostgreSQL 14

Memory settings recommendations
Current:
shared_buffers = 128MB
#effective_cache_size = 4GB
#maintenance_work_mem = 64MB
#work_mem = 4MB
Recommended:
shared_buffers = 989173kB
effective_cache_size = 2897MB
maintenance_work_mem = 494586kB
work_mem = 9891kB
success: memory settings will be updated

Parallelism settings recommendations
Current:
missing: timescaledb.max_background_workers
#max_worker_processes = 8
#max_parallel_workers_per_gather = 2
#max_parallel_workers = 8
Recommended:
timescaledb.max_background_workers = 16
max_worker_processes = 21
max_parallel_workers_per_gather = 1
max_parallel_workers = 2
success: parallelism settings will be updated

WAL settings recommendations
Current:
#wal_buffers = -1
min_wal_size = 80MB
Recommended:
wal_buffers = 16MB
min_wal_size = 512MB
success: WAL settings will be updated

Background writer settings recommendations
Current:
Recommended:
success: background writer settings will be updated

Miscellaneous settings recommendations
Current:
#default_statistics_target = 100
#random_page_cost = 4.0
#checkpoint_completion_target = 0.9
max_connections = 100
#max_locks_per_transaction = 64
#autovacuum_max_workers = 3
#autovacuum_naptime = 1min
#effective_io_concurrency = 1
Recommended:
default_statistics_target = 500
random_page_cost = 1.1
checkpoint_completion_target = 0.9
max_connections = 50
max_locks_per_transaction = 64
autovacuum_max_workers = 10
autovacuum_naptime = 10
effective_io_concurrency = 256
success: miscellaneous settings will be updated
Saving changes to: /etc/postgresql/14/main/postgresql.conf

Second execution[edit]

timescaledb-tune --yes
Using postgresql.conf at this path:
/etc/postgresql/14/main/postgresql.conf

Writing backup to:
/tmp/timescaledb_tune.backup202302150731

success: shared_preload_libraries is set correctly

Recommendations based on 3.77 GB of available memory and 2 CPUs for PostgreSQL 14

Memory settings recommendations
success: memory settings are already tuned

Parallelism settings recommendations
success: parallelism settings are already tuned

WAL settings recommendations
success: WAL settings are already tuned

Background writer settings recommendations
Current:
Recommended:
success: background writer settings will be updated

Miscellaneous settings recommendations
success: miscellaneous settings are already tuned
Saving changes to: /etc/postgresql/14/main/postgresql.conf

See also[edit]

Advertising: