Translated with AI from the Russian original.
In the new version of Postgres Pro Enterprise, multi-master architecture performance when working with temporary objects increased by 70–80%
Postgres Professional has released version 18.6.2 of the enterprise DBMS Postgres Pro Enterprise. The update includes stability fixes, temporary table processing optimization, acceleration of data operations, and expanded capabilities for interacting with external databases.
The new version implements a mechanism for deferred creation of temporary table files, which reduces disk operations. The use of AVX2 instructions speeds up checksum calculations and sequential table scans. Bulk data insertion and complex query processing have also been improved. In multi-master architecture, performance when working with temporary objects increased by 70–80%.
To connect to MySQL, the mysql_fdw wrapper has been added, supporting the pushdown of filters, joins, and aggregate operations to the external database. Monitoring tools have been expanded with the experimental pgpro_stats_2 extension, which collects query and wait event statistics.
Changes also affected the BiHA cluster: additional leader management tools, network route settings, and backup integration have appeared. Parallel autovacuum has been designated as a stable tool with the ability to change the number of worker processes without restarting the DBMS.
In addition, modules for backup, auditing, and vector data processing have been updated. The developers also fixed a bug that could lead to a crash after executing TRUNCATE or VACUUM FULL commands.
