Re: severe performance issue with planner (fwd)

I sent this message to the list and although it shows up in the archives,
I did not receive a copy of it through the list, so I'm resending as I
suspect others did not see it either.

---------- Forwarded message ----------
Date: Sat, 13 Mar 2004 22:48:01 -0500 (EST)
From: Kris Jurka <books@ejurka.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Eric Brown <bigwhitecow@hotmail.com>, pgsql-performance@postgresql.org
Subject: Re: [PERFORM] severe performance issue with planner

On Thu, 11 Mar 2004, Tom Lane wrote:

> "Eric Brown" <bigwhitecow@hotmail.com> writes:
> > [ planning a 9-table query takes too long ]
>
> See http://www.postgresql.org/docs/7.4/static/explicit-joins.html
> for some useful tips.
>

Is this the best answer we've got?  For me with an empty table this query
takes 4 seconds to plan, is that the expected planning time?  I know I've
got nine table queries that don't take that long.

Setting geqo_threshold less than 9, it takes 1 second to plan.  Does this
indicate that geqo_threshold is set too high, or is it a tradeoff between
planning time and plan quality?  If the planning time is so high because
the are a large number of possible join orders, should geqo_threhold be
based on the number of possible plans somehow instead of the number of
tables involved?

Kris Jurka