Postgres Professional has released Postgres Pro Enterprise 17.5.1 DBMS with improved mechanisms for working with "1C:Enterprise".
According to the developers, the release introduces the first mechanisms on the market that solve the problem of long execution of the "month-end closing" procedure in 1C, speed up work with temporary tables, simplify the "vacuum" process, and more.
In PostgreSQL, the planner sometimes chooses the wrong plan due to the assumption of uniform data distribution. A new approach to selectivity estimation in Postgres Pro has proven effective in the 1C "Month-End Closing" test. According to tests, the closing speed increased almost 10 times: from 4 hours to 20 minutes.
Cleaning modified and unlocked pages in RAM simplifies the "vacuum" process, reducing the load on the system and speeding up 1C. Performance issues with grouping queries that arise when calculating the cost of goods sold in 1C have also been resolved. Parallel workers are used for this when scanning temporary tables.
Autovacuum now operates in multi-threaded mode, which speeds up cleaning under the load characteristic of 1C. Information about constantly appearing and disappearing 1C temporary tables in the Postgres system catalog is one of the main reasons for performance degradation in multi-user mode. The refined patch from 1C stores the temporary table catalog in RAM and separately from the system catalog. Among other innovations and improvements, the utility for configuring Postgres Pro has a specialized preset of settings for 1C and recovery from a backup of a separate database.
