X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 80129D1C9B5 for ; Sun, 14 Mar 2004 03:47:42 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 44825-02 for ; Sat, 13 Mar 2004 23:47:45 -0400 (AST) Received: from mail63.csoft.net (unknown [63.111.22.74]) by svr1.postgresql.org (Postfix) with SMTP id 91B68D1B8EA for ; Sat, 13 Mar 2004 23:47:40 -0400 (AST) Received: (qmail 8371 invoked by uid 1112); 14 Mar 2004 03:48:01 -0000 Date: Sat, 13 Mar 2004 22:48:01 -0500 (EST) From: Kris Jurka X-X-Sender: books@leary.csoft.net To: Tom Lane Cc: Eric Brown , pgsql-performance@postgresql.org Subject: Re: severe performance issue with planner In-Reply-To: <4726.1079064433@sss.pgh.pa.us> Message-ID: References: <4726.1079064433@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/183 X-Sequence-Number: 6039 On Thu, 11 Mar 2004, Tom Lane wrote: > "Eric Brown" 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