Новости Tantor

Tantor Labs has released the high-performance and secure Tantor Postgres 17 DBMS with a huge number of new features and improvements

With improved functionality and increased performance over the community version of PostgreSQL 17, Tantor Postgres DBMS 17.5.0 from Tantor Labs comes in multiple editions. The release includes new data security features, significant query planner optimizations, advanced monitoring mechanisms, and many other features not available in PostgreSQL 17.
Specifically, Tantor Postgres 17.5.0 includes an impressive set of protection mechanisms. Data stored on disk can be transparently encrypted thanks to the implementation of Transparent Data Encryption (TDE) technology as an extension. Selective encryption of individual tables and GOST algorithms are supported. The pg_sec_check utility identifies vulnerabilities by performing various checks and generates a detailed report with suggestions for fixing them. It can be tailored to a particular environment. With the addition of support for the OAuth 2.0 authentication protocol, apps may now safely access data without sharing user passwords, reducing the possibility of compromised credentials or unauthorized access. Only PostgreSQL 18 is anticipated to see such an improvement in the community version.
A number of significant performance enhancements have been implemented. The release includes a new extension, pg_stat_advisor, which allows you to analyze query execution plans and automatically create missing statistics. A new mechanism for working with temporary tables has been introduced: information about them can now be saved in RAM and synchronization with the disk has been streamlined. This fixes the problem of system catalog bloat causing performance degradation in apps that extensively use temporary tables. In order to offer precise and reliable statistics under heavy load, the new pg_stat_statements extension now allows sampling, aggregating, and normalizing of temporary table names.
The statistics collection system now includes options for precision analysis, including enhanced support for wide tables and tables with unevenly distributed values. To fine-tune the analysis depth at the column level, the SET STATMULTIPLIER command was added. The scope of SIMD instructions has been extended: in anticipation of PostgreSQL 18's advancements, concurrency is already available in Tantor Postgres 17.5.0.
The newly implemented Join Predicate Pushdown technology pushes joins inside GROUP BY subqueries, reducing the volume of data processed at an early stage. Instead of using the conventional index scan cost estimation, the query planner now chooses "covering" selective indexes automatically. Optimized substring search functions in Unicode strings are implemented in LIKE operator for mchar and mvarchar types.
New extensions have been added. Specifically, pg_stat_kcache tracks actual physical read and write operations, allowing you to identify performance bottlenecks that are undetectable by other monitoring tools. The pgvector extension adds vector data type and optimized similarity search algorithms used to handle multidimensional data representations in recommendation systems, semantic search, algorithms for pattern recognition, and integration with ML models. The pg_ivm extension provides incremental materialized views, updating them as data changes in the source tables. Analytical datamarts are updated faster and with reduced load on system resources, ensuring continuous access to up-to-date information without blocks.
Improved pg_throttle extension —cgroups mechanism is now supported to ensure workload isolation. Assigning particular users’ backends to predefined control groups helps improve system stability. We also introduced a tool for automatic configuration of diagnostic extensions (pg_store_plans, pg_stat_statements, pg_stat_kcache, auto_explain, pg_buffercache, and others), which simplifies the implementation of monitoring systems.
‘The release of Tantor Postgres 17.5.0 offers a huge number of new features, technologies, and improvements. We've tried to give our users a lot at once: upscale level of security with transparent data encryption and a security audit application, increased performance, considerable optimizations for "1C," as well as an entire array of tools for in-depth analytics and management. This is our most feature-rich and powerful version to date, and it's ready to tackle the most complex business challenges," says Vadim Yatsenko, CEO of Tantor Labs.
Read more about the innovations in Tantor Postgres DBMS 17.5.0 in the documentation.
2025-06-19 14:22 Tantor Postgres