storage optimization

Proxima integrates connection pooling, query proxying, and load balancing into the Postgres Pro Enterprise DBMS, enhancing efficiency and minimizing latency. It establishes multiple connections for client sessions, optimizes resource usage, and alleviates server burdens. Proxima redirects client queries to the leader node in a BiHA cluster, automating cluster topology management. Load balancing is under development to prevent overload on replicas. The pgpro_queue extension facilitates asynchronous message processing directly within the database, ensuring transactionality, prioritization, filtering, and reliable message storage. Postgres Pro 17 Enterprise introduces enhanced query plan management tools, including the pgpro_multiplan extension for storing multiple execution plans and a query registration assistant for managing queries. Adaptive Query Execution (AQE) and Adaptive Query Optimization (AQO Enterprise) improve complex query execution by dynamically rescheduling long-running queries and correcting planner errors based on execution history. Security enhancements include the pgpro_usage extension for tracking database object usage and identifying unnecessary access rights. The pgpro_ilm extension automates storage optimization by relocating rarely accessed data and compressing it. Infrastructure improvements include BiHA enhancements, multimaster support, and improved management of partitioned tables, along with the updated PPEM 2.0 for better UI and automatic instance tuning.