On Thu, Feb 12, 2026 at 6:41 AM Ajay Pal <[email protected]> wrote: > pg_plan_advice failed to match JOIN_ORDER advice because the genetic > algorithm never attempts the specific join path requested.
Seems expected. It is bad if using GEQO results in a crash or if the advice cause the expected outcome when the path is considered, but if the randomness of GEQO causes it not to consider the path the user wants, then the user either needs to stop using GEQO, or use less-strict plan advice, or just understand that this kind of outcome is a possibility. Thanks, -- Robert Haas EDB: http://www.enterprisedb.com
