Performance comparison of PostgreSQL and its TimescaleDB extension
Journal Title: Modern Innovations, Systems and Technologies - Year 2024, Vol 4, Issue 3
Abstract
This article considers the PostgreSQL database and its extension TimescaleDB. The purpose of this article is to compare the performance of databases when dealing with big data. Since nowadays, when developing applications, one of the first issues a developer thinks about is the choice of a database and the time to work with it, this topic remains relevant. Cloud storage was used to deploy both databases, as it has a number of advantages over deployment on a local machine, and the pgAdmin 4 user interface. To conduct the tests, a test dataset was generated, which is a time series with values of climatic indicators for 2011-2023. The article describes the structure of the test data, presents the database configuration parameters and SQL query listings. For each database the results of the execution time of the same query are presented. These results are presented in the form of histograms for each SQL query, loading and unloading of the whole dataset. After analysing them, their interpretation is presented. In conclusion, recommendations for selecting a database for specific purposes are offered.
Authors and Affiliations
A. I. Platonova
Determination of parameters of a trepanning machine for cleaning wool fibers
This article provides information about the technology of primary processing of wool and the feeding part of the baking machine. It analyzes the operating principle and types of baking machines at the enterprise of prima...
Software parameters affecting the reliability of telemetry data processing
Creation of any modern complex technical systems, as well as their management, is impossible without complex software. In this case, the most important technical task is to increase its reliability and fault tolerance. A...
The choice of the mode of operation of the stepping motors in the machines of the numerical software control
The article describes the principle of operation of stepping motors, given the definitions of the main elements. An alternative is to use a servomotor, but its installation requires a more complex control circuit. Moreov...
Economic efficiency of the agricultural sector: factors affecting productivity and competitiveness
In modern conditions, the importance of studying the effectiveness and competitive advantages of the agro-industrial complex and agricultural enterprises in the Russian Federation is increasing. This article analyzes var...
Pressures during roller squeezing of leather
With the solution of contact and hydraulic problems of roller squeezing of leather, mathematical models of the patterns of distribution of normal stress and hydraulic squeezers during roller squeezing of leather were obt...