07.06.11 00:45, Josh Berkus написав(ла):
All,
Just got this simple case off IRC today:
8.4.4
This plan completes in 100ms:
Filter: (NOT (hashed SubPlan 1))
9.0.2
This plan does not complete in 15 minutes or more:
Filter: (NOT (SubPlan 1))
"Hashed" is the key. Hashed subplans usually
Josh Berkus writes:
> Just got this simple case off IRC today:
> [ hashed versus non-hashed subplan ]
> I'm at a bit of a loss as to what's happening here.
Possibly work_mem is smaller in the second installation?
(If I'm counting on my fingers right, you'd need a setting of at least a
couple MB
All,
Just got this simple case off IRC today:
8.4.4
This plan completes in 100ms:
old_prod=# explain analyze select email from u_contact where id not in
(select contact_id from u_user);
QUERY PLAN
-
