Postgres Professional has announced the availability of the proprietary database management system Pro Enterprise 15.1.1, based on the PostgreSQL 15 codebase, which includes new features that are being integrated into the upcoming 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.
Key innovations:
- Support for Packages (collections of functions and procedures) in an Oracle style to simplify code migration from PL/SQL when transitioning from Oracle to Postgres. From a technical perspective, package support is an extension of the PL/pgSQL language syntax (with minor additions in the DBMS core), enabling a functional analogue of Oracle packages and introducing additional commands for working with them.
- Passing positional parameters to scripts in psql, allowing the creation of more flexible and universal shell scripts for working with the DBMS. In addition to clear advantages when designing new scripts, this will simplify the adaptation of SQL scripts during migration from the Oracle DBMS, where similar functionality is familiar to users.
- The pgpro_anonymizer extension for data masking (obfuscation) provides security for data storage in enterprise-level systems and allows the creation of anonymized database copies for use in testing and development environments.
- Based on pg_probackup, a new backup utility for enterprise environments, pg_probackup Enterprise, has been developed that features: a new input-output subsystem that enhances performance; support for the S3 protocol to store data in cloud systems; CFS (data compression) compatibility with the incremental backup creation mechanism; support for all backup creation 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.
- Readiness to work with the TimescaleDB extension (following the official announcement from the developer regarding support for PostgreSQL 15).
- Adding the tds_fdw module to simplify migration from MS SQL Server.
- Official support for Elbrus processors.
Source: opennet.ru
