Alberto Dalmaso <dalmaso(at)clesius(dot)it> wrote:
> I attach the explanation of the log query after setting all the
> enable to on. In this condition the query will never finish...
I notice that you many joins in there. If the query can't be
simplified, you probably need to boost the join_collapse_limit and
from_collapse_limit quite a bit. If planning time goes through the
roof in that case, you may need to enable geqo -- this is what it's
intended to help. If you try geqo, you may need to tune it; I'm not
familiar with the knobs for tuning that, so maybe someone else will
jump in if you get to that point.
-Kevin