X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 3D852D7D75
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Fri, 26 Aug 2005 20:48:18 -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 22863-10
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Fri, 26 Aug 2005 23:48:17 +0000 (GMT)
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 623C5D7D72
	for <pgsql-performance@postgresql.org>;
	Fri, 26 Aug 2005 20:48:15 -0300 (ADT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j7QNm5Zx026875;
	Fri, 26 Aug 2005 19:48:05 -0400 (EDT)
To: Mark Kirkwood <markir@paradise.net.nz>
Cc: Tobias Brox <tobias@nordicbet.com>,
	pgsql-performance@postgresql.org
Subject: Re: Limit + group + join 
In-reply-to: <430FA5BD.2070407@paradise.net.nz> 
References: <20050826002709.GK10328@tobias.lan>
	<430E85ED.60109@paradise.net.nz> <9501.1125071193@sss.pgh.pa.us>
	<430FA5BD.2070407@paradise.net.nz>
Comments: In-reply-to Mark Kirkwood <markir@paradise.net.nz>
	message dated "Sat, 27 Aug 2005 11:29:01 +1200"
Date: Fri, 26 Aug 2005 19:48:05 -0400
Message-ID: <26874.1125100085@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006]
X-Spam-Level: 
X-Archive-Number: 200508/463
X-Sequence-Number: 14210

Mark Kirkwood <markir@paradise.net.nz> writes:
> That doesn't explain why the nested loop is being kicked tho',

No, but I think the fuzzy-cost bug does.  There are two different issues
here.

			regards, tom lane