Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 72DB79FA4CA for ; Sun, 24 Dec 2006 15:21:27 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 20022-02 for ; Sun, 24 Dec 2006 15:21:20 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from outbound-mail-14.bluehost.com (outbound-mail-14.bluehost.com [69.89.18.114]) by postgresql.org (Postfix) with SMTP id 0CBB59FA4BB for ; Sun, 24 Dec 2006 15:21:19 -0400 (AST) Received: (qmail 27280 invoked by uid 0); 24 Dec 2006 19:14:39 -0000 Received: from unknown (HELO box54.bluehost.com) (70.98.111.54) by mailproxy1.bluehost.com with SMTP; 24 Dec 2006 19:14:39 -0000 Received: from vdsl-151-118-33-199.dnvr.qwest.net ([151.118.33.199] helo=issac.neighbourhood.com.home) by box54.bluehost.com with esmtp (Exim 4.52) id 1GyYnu-0003kV-Tf; Sun, 24 Dec 2006 12:14:39 -0700 From: Kevin Kempter To: pgsql-hackers@postgresql.org Subject: Questions about planner methods Date: Sun, 24 Dec 2006 12:15:18 -0700 User-Agent: KMail/1.9.5 Cc: pgsql-performance@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200612241215.18730.kevin@kevinkempterllc.com> X-Identified-User: {840:box54.bluehost.com:kevinkem:kevinkempterllc.com} {sentby:bopbeforesmtp 151.118.33.199 authed with kevinkempterllc.com} X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/510 X-Sequence-Number: 22566 Hi List(s); I'm wanting to find more details per the following methods, can someone explain to me exactly what each of these methods is, how its implemented in postgres or point me to some docs or README's that explain these methods? Some of 'em are obviously no-brainers but I'm writing a postgres book and want to make sure I convey the concepts properly and technically correct. - Bitmap Scans - Hash Aggregation - Hash Joins - Index Scans - Merge Joins - Nested Loop Joins - TID Scans Thanks in advance for your help...