On Thu, Feb 12, 2026 at 8:08 AM Robert Haas <[email protected]> wrote: > 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
sorry, this should have said "doesn't cause" > 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. -- Robert Haas EDB: http://www.enterprisedb.com
