Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id C90079FB1C6 for ; Mon, 6 Nov 2006 10:14:05 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 78222-02 for ; Mon, 6 Nov 2006 14:13:59 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail01.enterprisedb.com (mail01.enterprisedb.com [63.246.7.168]) by postgresql.org (Postfix) with ESMTP id 322329FA8EF for ; Mon, 6 Nov 2006 10:13:59 -0400 (AST) thread-index: AccBrc1SEb9C4EfgSE6Wxbbp+vSQ9w== Received: from [192.168.0.22] ([62.232.55.118]) by mail01.enterprisedb.com over TLS secured channel with Microsoft SMTPSVC(6.0.3790.1830); Mon, 6 Nov 2006 09:13:58 -0500 Message-ID: <454F42FF.3070901@enterprisedb.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2757 Date: Mon, 06 Nov 2006 14:13:19 +0000 Content-class: urn:content-classes:message Importance: normal From: "Heikki Linnakangas" User-Agent: Thunderbird 1.5.0.7 (X11/20060927) MIME-Version: 1.0 To: "Hannes Dorbath" Cc: Subject: Re: Yet another question on LIMIT performance :/ References: In-Reply-To: Content-Type: text/plain; format=flowed; charset="ISO-8859-1" Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 06 Nov 2006 14:13:58.0843 (UTC) FILETIME=[CD48F8B0:01C701AD] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/65 X-Sequence-Number: 21835 Hannes Dorbath wrote: > Though it should only have to join a few rows it seems to scan all rows. What makes you think that's the case? -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com