In addition to the normal configuration for TimescaleDB, we recommend the following settings that are specific to multi-node operation:
max_prepared_transactionsmust be set to a non-zero value on all data nodes (if not already set,
enable_partitionwise_aggregateshould be set to
onon the access node for good query performance. Otherwise, queries will not be pushed down to the data nodes.
jitshould be set to
offon the access node as JIT currently doesn't work well with distributed queries. JIT can still be enabled on the data nodes.
statement_timeoutshould be disabled on the data nodes and managed through the access node configuration if desired. This setting is disabled by default in PostgreSQL, but may be worth verifying in your specific environment.
READ COMMITTEDit is automatically upgraded to
REPEATABLE READwhenever a distributed operation takes place. If the isolation level is
SERIALIZABLE, it is not changed.
Each of the above settings parameters can be configured for the
postgresql.conf, typically located in the data
directory. If the file isn't there, connect to the node (
get the path with:
Note that it will be necessary to reload the configuration if modified.
Found an issue on this page?Report an issue!