Difference between revisions of "Timescaledb-tune --yes"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
{{lc}} | {{lc}} | ||
| + | [[timescaledb-tune]] --yes | ||
| + | == Example == | ||
[[timescaledb-tune]] --yes | [[timescaledb-tune]] --yes | ||
<pre> | <pre> | ||
Revision as of 07:32, 15 February 2023
timescaledb-tune --yes
Example
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
See also
Advertising:
