timescaledb-tune --yes
timescaledb-tune --yes
Examples
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
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
Advertising:
