Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 780AC1336FA7 for ; Thu, 28 Apr 2011 09:33:33 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 39611-06 for ; Thu, 28 Apr 2011 12:33:15 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from exprod7ob118.obsmtp.com (exprod7ob118.obsmtp.com [64.18.2.7]) by mail.postgresql.org (Postfix) with ESMTP id 30AB21337BE1 for ; Thu, 28 Apr 2011 09:33:15 -0300 (ADT) Received: from mail-ey0-f179.google.com ([209.85.215.179]) (using TLSv1) by exprod7ob118.postini.com ([64.18.6.12]) with SMTP ID DSNKTbleibcDD6EjFn8SJGF+T7oU1u9qa3Wd@postini.com; Thu, 28 Apr 2011 05:33:15 PDT Received: by eyg5 with SMTP id 5so864476eyg.10 for ; Thu, 28 Apr 2011 05:33:12 -0700 (PDT) Received: by 10.213.13.79 with SMTP id b15mr2865479eba.95.1303993990783; Thu, 28 Apr 2011 05:33:10 -0700 (PDT) Received: from [192.168.1.183] (dsl-hkibrasgw2-ff7ac300-240.dhcp.inet.fi [88.195.122.240]) by mx.google.com with ESMTPS id k57sm1258321eei.24.2011.04.28.05.33.08 (version=TLSv1/SSLv3 cipher=OTHER); Thu, 28 Apr 2011 05:33:09 -0700 (PDT) Message-ID: <4DB95E82.20904@enterprisedb.com> Date: Thu, 28 Apr 2011 15:33:06 +0300 From: Heikki Linnakangas User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; fi-FI; rv:1.9.1.16) Gecko/20110307 Icedove/3.0.11 MIME-Version: 1.0 To: Rishabh Kumar Jain CC: pgsql-performance@postgresql.org Subject: Re: Order of tables References: <361406.75324.qm@web137010.mail.in.yahoo.com> In-Reply-To: <361406.75324.qm@web137010.mail.in.yahoo.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201104/395 X-Sequence-Number: 43457 On 28.04.2011 12:20, Rishabh Kumar Jain wrote: > How the tables must be ordered in the list of tables in from statement? There is no difference in performance, if that's what you mean. (If not, then pgsql-novice or pgsql-sql mailing list would've be more appropriate) -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com