Postgres Professional has announced the release of Postgres Pro Enterprise for 1C 18.4.1. The update is aimed at large 1C installations where the database regularly faces complex queries, numerous connections, temporary tables, reports, and scheduled operations. In the official release notes , it is stated that the new version is based on PostgreSQL 18.4 and Postgres Pro Enterprise 18.3.2.
One of the main changes is the ability to use temporary tables, temporary sequences, and temporary views on the hot standby server. This feature is enabled by the parameter enable_standby_temp_tables together with enable_temp_memory_catalog and hot_standby. The practical meaning is simple: heavy reports and ETL processes can be offloaded to the standby server, relieving the primary node.
For the query planner, a mechanism has been added enable_join_predicate_pushdown. It allows pushing join conditions from the outer query into nested subqueries, enabling the optimizer to choose a more favorable execution plan. Additionally, selectivity estimation for large MCV lists has been accelerated and handling of limited samples has improved via planner_upper_limit_estimation; this should be noticeable in typical 1C scenarios, including period closing and report generation.
Fault tolerance tools have also been updated. The built-in solution BiHA has upgraded to version 1.8: multi-tier geodistribution and disaster recovery are no longer considered experimental, and the service connections between nodes can be protected with SSL certificates. Proxima has introduced adaptive load balancing considering CPU, memory, and disk I/O, as well as support for multiple connection addresses — IPv4, IPv6, and Unix sockets.
The release also includes new tools and extensions. pgpro_iheap adds the iheap table access method, designed to accelerate sequential scanning, and pgpro_temp_stats automatically collects statistics for temporary tables so that the planner does not operate blindly. For administrators, a utility has been added pgpro_validate, which checks the integrity of files, indexes, tables, system catalogs, and access rights in the Postgres Pro instance.
Since Postgres Pro Enterprise 18.4.1 is based on PostgreSQL 18.4, it also includes corrections from the PostgreSQL upstream. To update within the same major version, simply install the new release in the current directory, but when the ABI changes, developers recommend updating the supplied extensions or recompiling third-party ones.
Source: linux.org.ru
