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.
SELECT statements are only supported
except SELECT FOR UPDATE and
SELECT FOR SHARE.
Statements with volatile functions are not supported.
Multiple SQL statements in a query string are not supported.