Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 1336E475DC0 for ; Thu, 16 Jan 2003 00:07:48 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 607C8475C22 for ; Thu, 16 Jan 2003 00:07:47 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id h0G57q5u011771; Thu, 16 Jan 2003 00:07:52 -0500 (EST) To: Kevin Brown Cc: pgsql-performance@postgresql.org Subject: Re: 7.3.1 New install, large queries are slow In-reply-to: <20030116044847.GA29781@filer> References: <9B1C77393DED0D4B9DAA1AA1742942DA0E4BFD@pos_pdc.posportal.com> <11547.1042691700@sss.pgh.pa.us> <20030116044847.GA29781@filer> Comments: In-reply-to Kevin Brown message dated "Wed, 15 Jan 2003 20:48:47 -0800" Date: Thu, 16 Jan 2003 00:07:52 -0500 Message-ID: <11770.1042693672@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/133 X-Sequence-Number: 780 Kevin Brown writes: > Tom Lane wrote: >> ... Whether this is a bug or a feature depends on >> your point of view --- but there are folks out there who find it to be >> a life-saver. > Since it *does* depend on one's point of view, would it be possible to > have control over this implemented in a session-defined variable (with > the default in the GUC, of course)? I have no objection to doing that --- anyone care to contribute code to make it happen? (I think the trick would be to fold plain-JOIN jointree entries into FROM-list items in planner.c, somewhere near the code that hoists sub-SELECTs into the main join tree. But I haven't tried it, and have no time to in the near future.) regards, tom lane