X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id E20E09DC83F for ; Fri, 27 Jan 2006 05:10:31 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 80580-09 for ; Fri, 27 Jan 2006 05:10:32 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.193]) by postgresql.org (Postfix) with ESMTP id BACE89DC857 for ; Fri, 27 Jan 2006 05:10:29 -0400 (AST) Received: by zproxy.gmail.com with SMTP id 13so601707nzn for ; Fri, 27 Jan 2006 01:10:31 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=jCmYJm1wIyOIp36HCea4pczV087dRIWKPwogB8w1JCTb1rkhoDrZe2HURL6nQvME9fWgwmMgqehGXGd84RlvHhM16yMGGaHRj2EvOO4R1HY5FO/YCGQU77WPT9uOkv/ymR80/Ua2cXEUJClpL7bgrXLKuGCp6iJ2j5RmmE+AIb4= Received: by 10.64.220.7 with SMTP id s7mr106066qbg; Fri, 27 Jan 2006 01:10:31 -0800 (PST) Received: by 10.65.139.5 with HTTP; Fri, 27 Jan 2006 01:10:31 -0800 (PST) Message-ID: <29d3b0b90601270110w645eab52k41ea6e385f297ae4@mail.gmail.com> Date: Fri, 27 Jan 2006 10:10:31 +0100 From: andrew To: pgsql-sql@postgresql.org Subject: Re: filtering after join In-Reply-To: <200601261759.31184.peter_e@gmx.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <29d3b0b90601250927o2a5ee6e6mc33a7647da4438ce@mail.gmail.com> <200601261222.34906.peter_e@gmx.net> <29d3b0b90601260454g35817213o7d5a0e8a1e53ddf7@mail.gmail.com> <200601261759.31184.peter_e@gmx.net> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.209 required=5 tests=[AWL=0.209] X-Spam-Score: 0.209 X-Spam-Level: X-Archive-Number: 200601/191 X-Sequence-Number: 23980 I can see the final plan by using the EXPLAIN command. But I want to know the procedure of the planner in handling nesting queries. Can you direct me to the corresponding part of the code and/or the documents? Thanks. On 1/26/06, Peter Eisentraut wrote: > andrew wrote: > > How will the query planner do for a nesting query? Treat the > > subqueries as multiple queries and then link them together? > > where can I find the information (codes or documents)? > > Look at the execution plan using the EXPLAIN command. > > -- > Peter Eisentraut > http://developer.postgresql.org/~petere/ > -- andrew