rg
Subject: subquery plan rows = 1, but it's merge joined instead of index lookup
On Thu, 2024-04-11 at 15:57 +0300, ilya Basin wrote:
Is there some complexity limit after which the planner starts acting dumb?
Yes, "join_collapse_limit" and "from_collapse_limit".
You can t
On Thu, 2024-04-11 at 15:57 +0300, ilya Basin wrote:
> Is there some complexity limit after which the planner starts acting dumb?
Yes, "join_collapse_limit" and "from_collapse_limit".
You can try increasing them.
Yours,
Laurenz Albe