Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 535719FB351 for ; Fri, 9 Mar 2007 12:47:26 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 78940-02-2 for ; Fri, 9 Mar 2007 12:47:14 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from fmed.uba.ar (mail.fmed.uba.ar [157.92.152.1]) by postgresql.org (Postfix) with ESMTP id 551619FB5EC for ; Fri, 9 Mar 2007 12:47:14 -0400 (AST) Received: from [157.92.155.58] (unknown [157.92.155.58]) by fmed.uba.ar (Postfix) with ESMTP id E07D14C30F4; Fri, 9 Mar 2007 13:58:00 -0300 (ART) Message-ID: <45F18DC7.9050805@fmed.uba.ar> Date: Fri, 09 Mar 2007 13:39:35 -0300 From: Gerardo Herzig User-Agent: Mozilla Thunderbird 1.0.7 (X11/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane CC: pgsql-sql@postgresql.org Subject: Re: index not being used. Why? References: <45F176CA.3050107@fmed.uba.ar> <321.1173457766@sss.pgh.pa.us> In-Reply-To: <321.1173457766@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.193 tagged_above=0 required=5 tests=AWL, BAYES_50, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200703/117 X-Sequence-Number: 27755 Someday i will ask some question that will makes you think a little more. You'll see. I will populate the tables and redo the explain. Thanks dudes!! Gerardo >Gerardo Herzig writes: > > >>Watch the last row of the explain command. It makes a sequential scan on the pages table, like it is not using the index on the "id" field. >>The result itself is OK, but i will populate the tables so i think that later that sequential scan would be a problem. >> >> > >Why do you think that the plans won't change when the tables get bigger? > > regards, tom lane > > > >