Postgres Professional announced the availability of Proprietary DBMS PRO Enterprise 15.1.1, based on the PostegreSQL 15 code base and including new opportunities that are transferred to the following PostgressQl branches, as well as the glad of specific additions for highly loaded systems. DBMS supports the multimaster replication, compression of data at the block level, incremental backup, built -in pouler of connections, optimized tabletings, improved full -text search, automatic compilation and requests planning.
The main innovations:
- Support for packages (Packages, sets of functions and procedures) in the Oracle style to simplify the migration of code in PL/SQL when switching from Oracle to Postgres. From a technical point of view, package support is an expansion of PL/PGSQL syntax (with small additions in the DBMS nucleus), thanks to which the functional analogue of Oracle packages is implemented and a number of additional commands are introduced for working with them.
- The transfer of positional parameters to the script in PSQL, which allows you to create more flexible and universal Shell scripts for working with DBMS. In addition to obvious advantages when designing new scripts, this will simplify the adaptation of SQL scripts during migration with the Oracle DBMS, where such functionality is familiar to the user.
- PGPRO_ANNYMIZER PGPRO_ANNYMIZER for masking (obstructing) data that allows you to ensure the safety of data storage in corporate level systems, as well as create anonymous copies of the database for use in testing and development media.
- Based on PG_PROBACKUP, a new backup utility for the corporate media PG_PROBACKUP ENTERPRISE has been developed, which has been implemented: a new input-output subsystem that increases productivity; support for the S3 protocol for data storage in cloud systems; CFS compatibility (data compression) with a mechanism for creating incremental backups; Support for all modes of creating backups (Delta, Page and Ptrack); Support for compression algorithms LZ4 and ZSTD.
- New JSON processing functions from the SQL standard: 2016 in addition to the previously implemented JSONPATH.
- readiness to work with the extension of Timescaledb (after an official announcement by the developer about support for PostgreSQL 15).
- Add TDS_FDW module to simplify migration with MS SQL Server.
- Official support for Elbrus processors.
/Media reports cited above.