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:
Cursors are not supported.
SELECT statements are only supported
except SELECT FOR UPDATE and
SELECT FOR SHARE.
Statements with volatile functions are not supported.