X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5A227D1B195 for ; Wed, 7 Jul 2004 18:44:34 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 55971-10 for ; Wed, 7 Jul 2004 21:44:27 +0000 (GMT) Received: from mail.sinectis.com.ar (odin.sinectis.com.ar [216.244.192.158]) by svr1.postgresql.org (Postfix) with ESMTP id 1D309D1B18F for ; Wed, 7 Jul 2004 18:44:22 -0300 (ADT) Received: from spinalweb (mail.dtnet.com.ar [200.0.213.22]) (authenticated for gbarosio@sinectis.com.ar) by mail.sinectis.com.ar with ESMTP id i67Li7s23600; Wed, 7 Jul 2004 18:44:08 -0300 X-Originally_To: Date: Wed, 7 Jul 2004 18:45:42 -0300 From: Guido Barosio To: Joel McGraw Cc: pgsql-performance@postgresql.org Subject: Re: query plan wierdness? Message-Id: <20040707184542.515a73f5.gbarosio@sinectis.com.ar> In-Reply-To: <7B3E33EF2A10A84185E3667F6B9A1B781A0679@ECIEXCHANGE.eldocomp.com> References: <7B3E33EF2A10A84185E3667F6B9A1B781A0679@ECIEXCHANGE.eldocomp.com> Organization: SpinalWeb X-Mailer: Sylpheed version 0.8.2 (GTK+ 1.2.10; i386-redhat-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/36 X-Sequence-Number: 7427 The limit is tricking you. I guess a sequential scan is cheaper than an index scan with the limit 26 found there. I am wrong? Greets -- ------------------------------------------- Guido Barosio Buenos Aires, Argentina -------------------------------------------