Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 892D11337990
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon,  8 Nov 2010 05:13:43 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 71232-05
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon,  8 Nov 2010 09:13:36 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from manuel.natserv.net (p65-147.acedsl.com [66.114.65.147])
	by mail.postgresql.org (Postfix) with ESMTP id C0BDF1336B42
	for <pgsql-performance@postgresql.org>;
	Mon,  8 Nov 2010 05:13:35 -0400 (AST)
Received: from shelca (zoraida.natserv.net [66.114.65.147])
	by manuel.natserv.net (Postfix) with ESMTP id 39931FBDA;
	Mon,  8 Nov 2010 04:13:35 -0500 (EST)
References: <cone.1288183283.263738.5695.1000@shelca>
	<AANLkTi=VotmtMz5tYcnQ_5nDhZmsvp_9oYq43FF+qjnn@mail.gmail.com>
Message-ID: <cone.1289207615.79145.5158.1000@shelca>
X-Mailer: http://www.courier-mta.org/cone/
From: Francisco Reyes <lists@stringsutils.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Pgsql performance <pgsql-performance@postgresql.org>
Subject: Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds
Date: Mon, 08 Nov 2010 04:13:35 -0500
Mime-Version: 1.0
Content-Type: text/plain; format=flowed; charset="US-ASCII"
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.59 tagged_above=-10 required=5 tests=BAYES_00=-1.9,
	RCVD_IN_RP_RNBL=1.31
X-Spam-Level: 
X-Archive-Number: 201011/94
X-Sequence-Number: 41118

Robert Haas writes:

> This part looks really strange to me.  Here we have a nested loop
> whose outer side is estimated to produce 33 rows and whose outer side
> is estimated to produce 2 rows.

We have retained someone to help us troubleshoot the issue.
Once the issue has been resolved I will make sure to post our 
findings.