Added support for OAuth 2.0 authentication. For more information, see the OAuth Support and OAuth Validator Modules.

Performance of operations involving temporary tables has been improved.

pg_stat_statements has been enhanced to improved monitoring precision and performance:

Added precision statistics collection. Enables fine-grained control over statistics sampling for individual table columns using the ALTER TABLE ... ALTER COLUMN ... SET STAT MULTIPLIER command.

Expanded use of SIMD instructions has been added. Enhancements planned for PostgreSQL 18 are already available in Tantor SE 17.

Deferred allocation of temporary tables using the enable_delayed_temp_file setting has been implemented.

Added the enable_convert_exists_as_lateral_join setting, allowing the planner to convert EXISTS subqueries into LATERAL SEMI JOIN when possible for improve performance.

Planner behavior has been improved using the Join Predicate Pushdown technique.

Planner behavior has been improved by default use of covering indexes with selectivity consideration.

Operation of ANALYZE command for wide tables has been optimized.

Grouped queries typical for “Month-End Closing” operations in 1C:ERP has been optimized.

pg_diag_setup — automates the configuration of PostgreSQL performance diagnostics extensions such as pg_store_plans, pg_stat_statements, pg_stat_kcache, auto_explain, pg_buffercache, and others. This simplifies the integration of database monitoring systems.

pg_sec_check — audits the security of PostgreSQL database configurations. It automates the inspection of various security aspects: from server settings to database-specific parameters, and provides detailed reports on identified issues along with actionable recommendations for remediation.

oauth_base_validator - implements a simple OAuth 2.0 token validator for built-in support of the Device Authorization Flow.

pg_ivm - provides Incremental View Maintenance (IVM) feature for Tantor SE.

pg_stat_advisor - allows to analyze query performance and create additional statistics to improve query plan.

pg_stat_kcache - gathers statistics about real reads and writes done by the filesystem layer.

pg_tde - implements Transparent Data Encryption (TDE) at the storage level. It does not encrypt data in memory or during transmission over the network.

vector - allows to search vector similarity.

mchar - optimized operation of LIKE operator for mchar/mvarchar types by using more efficient Unicode functions for simple substring patterns.

pg_throttle - added the use of the cgroups mechanism for integration with Linux Control Groups.