Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id BFE3B47682B for ; Thu, 16 Jan 2003 10:46:30 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id A15A1476758 for ; Thu, 16 Jan 2003 10:46:18 -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 h0GFkN5u015060; Thu, 16 Jan 2003 10:46:23 -0500 (EST) To: Kevin Brown Cc: pgsql-performance@postgresql.org Subject: Re: 7.3.1 New install, large queries are slow In-reply-to: <20030116104025.GB29781@filer> References: <9B1C77393DED0D4B9DAA1AA1742942DA0E4BFD@pos_pdc.posportal.com> <11547.1042691700@sss.pgh.pa.us> <20030116044847.GA29781@filer> <11770.1042693672@sss.pgh.pa.us> <20030116104025.GB29781@filer> Comments: In-reply-to Kevin Brown message dated "Thu, 16 Jan 2003 02:40:25 -0800" Date: Thu, 16 Jan 2003 10:46:22 -0500 Message-ID: <15059.1042731982@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/149 X-Sequence-Number: 796 Kevin Brown writes: > I'm looking at the code now (the 7.2.3 code in particular, but I > suspect for this purpose the code is likely to be very similar to the > CVS tip), but it's all completely new to me and the developer > documentation isn't very revealing of the internals. The optimizer > code (I've been looking especially at make_jointree_rel() and > make_fromexpr_rel()) looks a bit tricky...it'll take me some time to > completely wrap my brain around it. Any pointers to revealing > documentation would be quite helpful! src/backend/optimizer/README is a good place to start. I'd recommend working with CVS tip; there is little point in doing any nontrivial development in the 7.2 branch. You'd have to port it forward anyway. regards, tom lane