NextGen Archiver (NGA) - FAQ

Is it recommended to add all data points to archive to only one group or is it better to add them to different groups?

If data point elements have different change rates and also different time periods for how long they should be available for online queries, it should be considered to create several groups, e.g. for "unsolicited values" and "compressed values" etc.

The more data point elements a project has, the more important this grouping becomes.

What is the record size per database?

The following table shows the record size per database:

InfluxDB®

Record size, Bytes *

PostgreSQL®

Record size, Bytes *

MS SQL®

Record size, Bytes *

Event/record 15 130 105
Alert (Came-went-acknowledged) 115 370 200
* The record size is an average value based on tests.

How can a backup of the segments be made?

The backup of segments can be done in several ways:

Which amount of data should be available online in the database?

The amount of data available in the database (online data) should preferably be small (total size of online data). The retention period should be chosen accordingly, depending on the data needed for the ongoing operation of the system. Backed up archives can be restored at any time if needed.

Is there a limit to the number of "backed up segments"?

How much data can be backed up depends on the size of the backup medium.

The location for the backup must be configured as follows: