Welcome to the new Schneider Electric Community

It's your place to connect with experts and peers, get continuous support, and share knowledge.

  • Explore the new navigation for even easier access to your community.
  • Bookmark and use our new, easy-to-remember address (community.se.com).
  • Get ready for more content and an improved experience.

Contact SchneiderCommunity.Support@se.com if you have any questions.

Close
Invite a Co-worker
Send a co-worker an invite to the Exchange portal.Just enter their email address and we’ll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
84590members
353857posts

Postgres TimeScale database understandings

EcoStruxure IT forum

A support forum for Data Center Operation, Data Center Expert, and EcoStruxure IT product users to share knowledge on installation, configuration, and general product use.

pogie_email_cz_
Cadet
0 Likes
1
411

Postgres TimeScale database understandings

Hi everyone, we'd like to optimize data in our Building Operation WorkStation. We have many units, which inserts stats into TimeScale Postgres database under Windows. 

Parameter "Delta" says "if there is value more than this parameter, write to DB", otherwise write stats into DB after "Maximum log interval" value.

The problem is, if the value delta is wrongly set, there are thousands of inserts into DB and the DB grow up quickly. 

Now we'd like to create SQL query, which returns "first 20 from TimeScaleDB with the highest frequency inserted value in the specific interval (for example 14 days).

The query itself is simple. The problem is in DB, which is very complex and not intuitive. Now my question is:

 

Does exist any other way how to determine units with the most inserts in the whole TimeScale DB?

OR 

Does exist technical specification of Building Operation WorkStation, which specify postresql database specification and operation insertion?

 

Our system is running on:

Building Operation WorkStation version 3.2.1.630

Postgres 1.9.1

TimeScale 11_1.7.4

 

Thank you

 

Regards

 

Jiri

Tags (1)
1 Reply 1
Hilll
Crewman
Crewman
0 Likes
0
400

Re: Postgres TimeScale database understandings

TimescaleDB is an open-source database invented to make SQL scalable for time-series data. It’s a relatively new database system. TimescaleDB has been introduced to the market two years ago and reached version 1.0 in September 2018. Nevertheless, it’s engineered on top of a mature RDBMS system. TimescaleDB is packaged as a PostgreSQL extension. All code is licensed under the Apache-2 open-source license, Target Card Balance Now with the exception of some source code related to the time-series enterprise features licensed under the Timescale License (TSL).

Tags (1)