{"repo":"timescale/timescaledb-tune","free":true,"listed":false,"github":"https://github.com/timescale/timescaledb-tune","clone":"git clone https://github.com/timescale/timescaledb-tune.git","description":"A tool for tuning TimescaleDB for better performance by adjusting settings to match your system's CPU and memory resources.","language":"Go","stars":501,"topics":["postgresql","timescaledb","tuning"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"timescaledb-tune timescaledb-tune is a program for tuning a TimescaleDB database to perform its best based on the host's resources such as memory and number of CPUs. It parses the existing postgresql.conf file to ensure that the TimescaleDB extension is appropriately installed and provides recommendations for memory, parallelism, WAL, and other settings. Getting started You need the Go runtime (1.18+) installed, then simply go install this repo: It is also available as a binary package on a variety systems using Homebrew, yum , or apt . Search for timescaledb-tools . Using timescaledb-tune By default, timescaledb-tune attempts to locate your postgresql.conf file for parsing by using heuristics based on the operating system, so the simplest invocation would be: You'll then be given a series of prompts that require minimal user input to make sure your config file is up to date: If you have moved the configuration file to a different location, or auto-detection fails (file an issue please!), you can provide the location with the --conf-path flag: At the end, your postgresql.conf will be overwritten with the changes that you accepted from the prompts. Other invocations By default, timescaledb-tune provides recommendations for a typical timescaledb workload. The --profile flag can be used to tailor the recommendations for other workload types. Currently, the only non-default profile is \"promscale\". The TSTUNE PROFILE environment variable can also be used to affect this behavior. I","default_branch":null,"files":null,"tree":[],"storefront":"/r/timescale","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/timescale/timescaledb-tune/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}