Chapter 75. Real-Time Query Replanning
Table of Contents
Real-time query replanning enables replanning a query if during the query execution, some trigger indicates a non-optimal execution, so a more optimal plan should be looked for.
Real-time query replanning is disabled by default and can be enabled with the configuration parameter replan_enable.
Replanning currently has the following limitations:
Prepared queries are not supported.
Cursors are not supported.
SELECTstatements are only supported exceptSELECT FOR UPDATEandSELECT FOR SHARE.Statements with volatile functions are not supported.
Multiple SQL statements in a query string are not supported.