Andres Freund <and...@anarazel.de> writes: > On Thursday 16 July 2009 17:16:31 Tom Lane wrote: >> I tried the example query and couldn't get "Failed to make a valid plan" >> out of it ... what settings do you need for that?
> It unfortunately depends on settings and luck. This dependence on luck was > the > reason why I liked geqo to behave "somewhat" deterministically... > With {join,from}_collapse_limit = 100 it seems to be triggered reliably. > With > lower values it seems harder trigger, with bigger it simply takes too long to > even get there. OK, I see it at 100. Would you confirm that what you get is the failure in random_init_pool (geqo_pool.c) not the identically-phrased message elsewhere? (If you have VERBOSITY = verbose you should see the error location info.) regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers