General configuration for all backends
This chapter contains the common settings for the databases PostgreSQL® and MS SQL®.
This list of values are key/value pairs for the configuration of these settings. The names (keys) are predefined by the backend in backend profile - see configuration of the backend profile. The further chapters are database-specific for the three different databases InfluxDB®, PostgreSQL® and MS SQL®.

Logger for PostgreSQL® and MS SQL®
-
logger.level - the level of the log messages that produce the backend. Possible values are "trace", "debug", and "info", "warn" and "error".
The default value is "info".
-
logger.logProtobufMessages – Set this flag to 1 for logging protobuf messages from/to frontend.
The default value is 0.
-
logger.logToStdOut - Set this flag to 1 for logging parameters of the DB queries.
The default value is 0.
-
logger.logSql - Set this flag to 1 for logging SQL messages to DB. The default value is 0.
-
logger.logSqlBindedParameters - Set this flag to 1 for logging parameters of the DB queries. The default value is 0
Backend configuration for PostgreSQL® and MS SQL®
-
backend.readThreadsNumber - size of thread pool for reading threads.
The default is the number of CPU cores running on the computer. The backend splits read requests according to archive groups of requested elements.
Each read request for a given archive group is executed in a separate thread. The size of the thread pool defines maximum threads that might be used simultaneously for handling read requests.
If a value smaller than one is specified, the default value is used.
For new PostgreSQL® databases created via a new project, the entrymax_parallel_workers
in the filepostgresql.conf
is set to the number of cores running on the computer.Once this has been done, the number of read threads in the PostgreSQL® backend (
backend.readThreadsNumber
) is adjusted to this number. This is only done for the standard backend_NGA_B_PostgreSQLBackend
and is neither adjusted for other backends nor for existing projects.With these settings, the performance is improved for many parallel queries, for example in projects with many data point functions.
-
backend.writeThreadsNumber - size of thread pool for writing threads. The default value is 50. If a value smaller than one is specified, the default value is used.