On Thu, Feb 12, 2026 at 6:41 AM Ajay Pal <ajay.pal.k@gmail.com> 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
