Re: join over 12 tables takes 3 secs to plan

Hilmar Lapp wrote:

> We are in fact an Oracle shop, but the application I tried to get
> running (http://trackplus.sourceforge.net/) I wanted to run on an OSS
> RDBMS so that I could easily move it onto my laptop etc (BTW
> apparently it was primarily developed on InterBase/Firebird). Anyway,
> I was able to cut the planning time for those queries in half by
> setting geqo_pool_size to 512. However, now it gets stuck for an
> excessive amount of time after the issue update page and I have no
> idea what's going on, and I'm not in the mood to track it down. So
> finally I'm giving up and I'm rolling it out on MySQL on which it is
> working fine, even though I don't like MySQL to say the least.
>
> -hilmar
>
Uhoh, did I just hear a gauntlet thrown down ... works well on MySQL but
not on PostgreSQL. If I can find the time, perhaps I can take a look at
the specific query(ies) and see what is missed in PostgreSQL that MySQL
has gotten right.

If only there were 48 hours in a day :-).

Charlie

--

Charles H. Woloszynski

ClearMetrix, Inc.
115 Research Drive
Bethlehem, PA 18015

tel: 610-419-2210 x400
fax: 240-371-3256
web: www.clearmetrix.com