Service Settings - Database configuration
Timescale Cloud allows you to customize many TimescaleDB and PostgreSQL configuration options for each Service individually. Most configuration values for a service are initially set in accordance with best practices given the compute and storage settings of the service. Any time you increase or decrease the compute for a Service, the most essential values are set to reflect the size of the new service.
There are times, however, when your specific workload could require tuning some of the many available TimescaleDB and PostgreSQL parameters. By providing the ability to tune various runtime settings, Timescale Cloud provides the balance and flexibility you need when running your workloads in our hosted environment.
View service operation details
To modify configuration parameters, first select the Service that you want to
modify. This displays the
service details, with these tabs across the top:
Overview, Operations, Metrics, Logs, and Settings. Select
Modify basic parameters
Under the Settings tab, you can modify a limited set of the parameters that are most often modified in a TimescaleDB or PostgreSQL instance. To modify a configured value, click the value that you would like to change. This reveals an editable field to apply your change. Clicking anywhere outside of that field saves the value to be applied.
max_connectionsis 0 to 25 in the smallest compute tier, but 25 to 500 in the next tier.
Apply configuration changes
When you have modified the configuration parameters that you would
like to change, click
Apply Changes. For some changes, such as
timescaledb.max_background_workers (pictured below), the Service needs to be
restarted. In this case, the button reads
Restart and apply changes.
Regardless of whether the service needs to be restarted or not, a confirmation
dialog is displayed which lists the parameters that are being modified. Click
Confirm to apply the changes (and restart if necessary).
Found an issue on this page?Report an issue!