X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6B559329DE0 for ; Mon, 4 Oct 2004 23:29:07 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 84417-10 for ; Mon, 4 Oct 2004 22:29:01 +0000 (GMT) Received: from hotmail.com (bay2-f24.bay2.hotmail.com [65.54.247.24]) by svr1.postgresql.org (Postfix) with ESMTP id 6E1C4329D76 for ; Mon, 4 Oct 2004 23:29:02 +0100 (BST) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Mon, 4 Oct 2004 15:29:01 -0700 Received: from 128.174.244.232 by by2fd.bay2.hotmail.msn.com with HTTP; Mon, 04 Oct 2004 22:28:32 GMT X-Originating-IP: [128.174.244.232] X-Originating-Email: [dbresearch@hotmail.com] X-Sender: dbresearch@hotmail.com From: "Steve Jackson" To: tgl@sss.pgh.pa.us Cc: pgsql-docs@postgresql.org Subject: Re: directly construct a query plan Date: Mon, 04 Oct 2004 17:28:32 -0500 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 04 Oct 2004 22:29:01.0712 (UTC) FILETIME=[8C63D900:01C4AA61] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/11 X-Sequence-Number: 2580 Hi Tom, Thanks! So if I want to try out some new join algorithm, or even new type of plan nodes, before I feel the algorithms/nodes are so good that I want to enable the optimizer to consider them as options, is there any better way to experiment with possible new plans? regards, Steve > > I plan to directly construct a query plan without going through the >query > > optimizer, by manipulating the various data structures for representing > > query plan tree and parse tree. Is there any facility inside/outside > > postgresql that can be of help? Is there any known issue/difficulty >related > > to this? > >Only that your code *will* break in each future release, because we have >no hesitation about whacking those data structures around ... > > regards, tom lane _________________________________________________________________ On the road to retirement? Check out MSN Life Events for advice on how to get there! http://lifeevents.msn.com/category.aspx?cid=Retirement