RapidGate

[Mikhail]

Hi,
Thank you for the details.

> As for why calculated channels always 0 is due to I enable the formula with 0. I disable the formula and problem solved.
There is also a general server option to disable channel formulas.

> Looks like the “converting DAT files to PostgreSql database” is success.
That’s good!

[kcks66]

Hi Mikhail,

So far I had converting historical data from 01/01/2022 to up to date. One thing I noticed id historical data stored in PostgreSql database consumed very high storage size (350GB) compared to its DAT files (55GB)

PostgreSql database size:
https://ibb.co/93vtwPy

DAT files size:
https://ibb.co/8dMxV05

Is this normal?
Thank you.

[Mikhail]

Hi,
DAT format is optimized for SCADA data.
How many data points in the database? A data point is 1 channel’s data at a timestamp.

[kcks66]

Hi Mikhail,

I have 2688 channels.

[Mikhail]

Hi,
How many slices in a day? How many days?

[kcks66]

Hi Mikhail,

I have no idea how to count slices. I screen shot as below:

https://ibb.co/vDbQd6t

So far around 850 days.

[Mikhail]

Hi,
Saving data every minutes generates 1440 slices per day.
So, there are 1440 * 850 * 2688 = 3 290 112 000 data points.
Therefore the archive size is big.

[kcks66]

Hi Mikhail,

Got it. Thx.

[Author]

Posts