Received: from localhost (uranus.hub.org [200.46.204.60])
	by postgresql.org (Postfix) with ESMTP id 6E7AA9FB1CE
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Mon,  6 Nov 2006 10:18:06 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.60]) (amavisd-new, port 10024)
	with ESMTP id 68924-05 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Mon,  6 Nov 2006 10:18:03 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2])
	by postgresql.org (Postfix) with ESMTP id 9B71C9FAE4E
	for <pgsql-performance@postgresql.org>;
	Mon,  6 Nov 2006 10:18:03 -0400 (AST)
Received: by floppy.pyrenet.fr (Postfix, from userid 106)
	id 4F16C308F7; Mon,  6 Nov 2006 15:18:01 +0100 (MET)
From: Hannes Dorbath <light@theendofthetunnel.de>
X-Newsgroups: pgsql.performance
Subject: Re: Yet another question on LIMIT performance :/
Date: Mon, 06 Nov 2006 15:21:35 +0100
Organization: Hub.Org Networking Services
Lines: 13
Message-ID: <454F44EF.1090401@theendofthetunnel.de>
References: <einfmm$r41$1@news.hub.org> <454F42FF.3070901@enterprisedb.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Complaints-To: usenet@news.hub.org
To: Heikki Linnakangas <heikki@enterprisedb.com>
User-Agent: Thunderbird 1.5.0.7 (Windows/20060909)
In-Reply-To: <454F42FF.3070901@enterprisedb.com>
To: pgsql-performance@postgresql.org
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200611/66
X-Sequence-Number: 21836

On 06.11.2006 15:13, Heikki Linnakangas wrote:
> 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?

Sorry, not all rows, but 80753. It's not clear to me why this number is 
so high with LIMIT 10.


-- 
Regards,
Hannes Dorbath