Manual PostgreSQL configuration and tuning
If you prefer to tune settings yourself, or for settings not covered by
timescaledb-tune, you can manually configure your installation using the PostgreSQL configuration file.
For some common configuration settings you might want to adjust, see the about-configuration page.
For more information about the PostgreSQL configuration page, see the PostgreSQL documentation.
The location of the PostgreSQL configuration file depends on your operating
system and installation. You can find the location by querying the database as
postgres user, from the psql prompt:
The configuration file requires one parameter per line. Blank lines are ignored,
and you can use a
# symbol at the beginning of a line to denote a comment.
When you have made changes to the configuration file, the new configuration is
not applied immediately. The configuration file is reloaded whenever the server
SIGHUP signal, or you can manually reload the file uses the
If you don't want to open the configuration file to make changes, you can also
set parameters directly from the command prompt, using the
postgres -c log_connections=yes -c log_destination='syslog'
Found an issue on this page?Report an issue!