formed Corrective updates for all supported branches PostgreSQL: 14.2 , 13.6 , 12.10 , 11.15 and 10.20 , in which 55 errors identified over the past three months have been fixed. Including the problems that caused the circumstances with a rare circumstance to damage the indices when changing the chains Toast .
Emergency completions are eliminated when performing Alter Statistics and when removing data from multirange-tizes . The query scheduler eliminated errors that conclude incorrect results. Memory leaks are eliminated when updating indices by expressions and when performing the operation “REASSIGN OWNED by” over a large number objects. Constructed extended statistics for segmented tables.
Additionally, you can note release Utilities Reshape , allowing without stopping the work to make complex updates of the data schema in PostgreSQL, under normal conditions requiring manual changes and temporary stopping of services that use the database.
Utility makes it possible Go with an old data schema to a new one without long blocking and without interrupting the cycle Request processing. The utility automatically creates views of the tables with which the applications continue to operate during the data migration of the data circuit, and also configures triggers that broadcast operations for adding and deleting data between old and new schemes.
Thus, when used
Reshape During the migration, the old and new scheme simultaneously remains available and applications can be gradually transferred to a new scheme without stopping the work (in large infrastructures you can gradually replace handlers with old on new). After completing the transfer of applications to a new scheme created to save support for the old presentation scheme and triggers are deleted. In case of identifying problems with applications during migration, you can cancel the change of the circuit and return to the old state.