The DBMS TimescaleDB 2.0 release has been published, version in which changes were added to the TSL license to provide users with more rights and allow free use of all the features of the enterprise version, including compression, storage distribution across multiple nodes and continuous aggregation. The license removed restrictions on the scope of community assembly, granted the right to make improvements and changes, removed paid bindings (all features previously offered in TimescaleDB Enterprise have been carried over to the Community edition).
For those unfamiliar with TimescaleDB, you should know that is implemented as a PostgreSQL extensiondesigned to store and process data in the form of a time series (portions of parameter values at specified time intervals, the record forms a time and a set of values corresponding to this time).
This form of storage is optimal for applications such as monitoring systems, trading platforms, systems for collecting metrics and sensor states. The means to integrate with the Grafana and Prometheus project are provided.
The key feature of TimescaleDB is its support for automatic partitioning of the data array, As well as the flow of input data is automatically distributed among the partitioned tables and that the sections are created according to time (each section stores data for a certain period of time) or in relation to an arbitrary key.
Main new features in TimescaleDB 2.0
In this new version a new implementation of continuously executed functions is proposed They allow you to continually add incoming data in real time (they resemble materialized PostgreSQL views, but differ in that they provide automatic calculation of query results in the background as data arrives or changes).
The new implementation is highlighted by an API change, which now explicitly separates functions and aggregation rules, allowing you to implement features such as manually updating a specific range in an aggregated view (for example, you can automatically materialize new data, but leave old historical data for manual updating). The changes will also make it possible in the future to implement support for distributed operations when working with multiple nodes.
Another important change is the support for user-defined actions (UDA, User Defined Action) to execute functions and procedures on a schedule written in arbitrary languages. The new feature is suitable for performing periodic tasks that are not covered by existing controller connection policies (stale data cleanup, compression, and continuous aggregation).
Added support for distributed hypertext, allowing storage to be spread across multiple nodes with TimescaleDB. The TimescaleDB-based cluster configuration includes one access node and multiple storage nodes. All requests to the distributed hypertext are directed to the access node and then distributed among the storage nodes.
Added support for new informational views, allowing you to get information about hypertext, cluster nodes, strings, policies, and job startup schedule.
How to install TimescaleDB on Linux?
For those who are interested to be able to install TimescaleDB on your systemThey can do so by following the instructions we share below.
In the case of those that are Ubuntu users:
sudo echo "deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -c -s)-pgdg main" | sudo tee /etc/apt/sources.list.d/pgdg.list wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add – sudo add-apt-repository ppa:timescale/timescaledb-ppa sudo apt-get update sudo apt install timescaledb-postgresql-11
In the case of debbian:
sudo sh -c "echo 'deb https://packagecloud.io/timescale/timescaledb/debian/ `lsb_release -c -s` main' > /etc/apt/sources.list.d/timescaledb.list" wget --quiet -O - https://packagecloud.io/timescale/timescaledb/gpgkey | sudo apt-key add - sudo apt-get update sudo apt-get install timescaledb-postgresql-11
RHEL / CentOS:
sudo yum install -y https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
sudo tee /etc/yum.repos.d/timescale_timescaledb.repo <<EOL [timescale_timescaledb] name=timescale_timescaledb baseurl=https://packagecloud.io/timescale/timescaledb/el/7/\$basearch repo_gpgcheck=1 gpgcheck=0 enabled=1 gpgkey=https://packagecloud.io/timescale/timescaledb/gpgkey sslverify=1 sslcacert=/etc/pki/tls/certs/ca-bundle.crt metadata_expire=300 EOL
sudo yum update -y sudo yum install -y timescaledb-postgresql-11
Now we are going to configure the database with:
sudo timescaledb-tune
Here various configurations can be made, of which you can consult In the following link.
At the end, just restart the service:
sudo service postgresql restart