Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 4EBA7476CEE for ; Thu, 2 Jan 2003 19:36:11 -0500 (EST) Received: from clearmetrix.com (unknown [209.92.142.67]) by postgresql.org (Postfix) with ESMTP id A66D64766F6 for ; Thu, 2 Jan 2003 19:36:10 -0500 (EST) Received: from clearmetrix.com (chw.muvpn.clearmetrix.com [172.16.1.3]) by clearmetrix.com (8.11.6/linuxconf) with ESMTP id h030aAg19710; Thu, 2 Jan 2003 19:36:10 -0500 Message-ID: <3E14DAFC.3080409@clearmetrix.com> Date: Thu, 02 Jan 2003 19:36:12 -0500 From: "Charles H. Woloszynski" User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.2.1) Gecko/20021130 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Hilmar Lapp Cc: Ron Johnson , PgSQL Performance ML Subject: Re: join over 12 tables takes 3 secs to plan References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/20 X-Sequence-Number: 667 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