Configuring TimescaleDB

TimescaleDB works with the default PostgreSQL server configuration settings. However, we find that these settings are typically too conservative and can be limiting when using larger servers with more resources (CPU, memory, disk, etc). Adjusting these settings, either automatically with our tool timescaledb-tune or manually editing your machine’s postgresql.conf, can improve performance.

tip

You can determine the location of postgresql.conf by running SHOW config_file; from your PostgreSQL client (e.g., psql).

In addition, other TimescaleDB specific settings can be modified through the postgresql.conf file as discussed in our section about TimescaleDB settings