Difference between revisions of "Timescaledb-tune --yes"
Jump to navigation
Jump to search
| Line 79: | Line 79: | ||
=== Second execution === | === Second execution === | ||
| + | <pre> | ||
| + | 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 | ||
| + | </pre> | ||
== See also == | == See also == | ||
Revision as of 07:32, 15 February 2023
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:
