Postgres Professional has announced the availability of its proprietary Pro Enterprise 15.1.1 DBMS, based on the PostgreSQL 15 code base and including new features that have been transferred for integration into the next PostgreSQL branches, as well as a number of specific additions for high-load systems. The DBMS supports multi-master replication, block-level data compression, incremental backups, a built-in connection pooler, optimized table partitioning, improved full-text search, automatic query compilation and scheduling.
Main innovations:
- Support for Oracle-style packages (Packages, sets of functions and procedures) to simplify the migration of PL/SQL code when migrating from Oracle to Postgres. From a technical point of view, package support is an extension of the PL / pgSQL language syntax (with minor additions to the DBMS core), thanks to which a functional analogue of Oracle packages is implemented and a number of additional commands are introduced to work with them.
- Passing positional parameters to a script in psql, which allows you to create more flexible and versatile shell scripts for working with the DBMS. In addition to obvious advantages when designing new scripts, this will simplify the adaptation of SQL scripts when migrating from Oracle DBMS, where such functionality is familiar to the user.
- The pgpro_anonymizer extension for data masking (obfuscation), which allows you to ensure the security of data storage in enterprise-level systems, as well as create anonymized copies of the database for use in test and development environments.
- Based on pg_probackup, a new backup utility for corporate environments pg_probackup Enterprise has been developed, which implements: a new I / O subsystem that improves performance; support for the S3 protocol for storing data in cloud systems; compatibility of CFS (data compression) with the mechanism for creating incremental backups; support for all backup modes (DELTA, PAGE and PTRACK); support for LZ4 and ZSTD compression algorithms.
- New JSON processing functions from the SQL:2016 standard in addition to the previously implemented JSONPATH language.
- Ready to work with the TimescaleDB extension (after the official announcement by its developer about PostgreSQL 15 support).
- Adding the tds_fdw module to simplify migration from MS SQL Server.
- Official support for Elbrus processors.
Source: opennet.ru