Postgres Professional has released Postgres Pro Enterprise 17.6, which includes enhancements for 1C users. Key features include:
- Official documentation for configuring Postgres Pro with 1C solutions, consolidating best practices for performance tuning and cluster operation.
- Suppression of excessive catalog cache invalidation messages during index creation or dropping on temporary tables and statistics gathering.
- Introduction of the skip_temp_rel_lock parameter to bypass lock acquisition for temporary relations and their indexes, improving performance during frequent DDL operations.
- Reengineered TRUNCATE operations for temporary tables, allowing for a single scan of the buffer pool, enhancing efficiency.
- Improved substring search performance in 1C applications by enabling accurate cost estimation for LIKE operators on mvarchar fields.
- Memoization support for parameterized ANTI JOIN nodes, reducing unnecessary data processing cycles in complex queries.
- Reduced lock requests during query planning involving multiple relations, improving operation when new sessions connect.
- Optimized VACUUM ANALYZE on catalog tables, ensuring the pg_internal.init file remains intact during analysis, allowing for swift new session connections.