Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id BD5B2633A4B
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon, 23 Mar 2009 16:56:31 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 08674-01-2
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon, 23 Mar 2009 16:56:25 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from sp-exchfea.sp.corp.collab.net (sp-exchfea.sp.corp.collab.net
	[204.16.106.198])
	by mail.postgresql.org (Postfix) with ESMTP id B78AA635BCF
	for <pgsql-performance@postgresql.org>;
	Mon, 23 Mar 2009 16:56:23 -0300 (ADT)
Received: from [204.11.125.147] ([204.11.125.147]) by
	sp-exchfea.sp.corp.collab.net with Microsoft SMTPSVC(6.0.3790.3959);
	Mon, 23 Mar 2009 12:56:20 -0700
Message-ID: <49C7E95B.3050502@collab.net>
Date: Mon, 23 Mar 2009 12:56:11 -0700
From: Anne Rosset <arosset@collab.net>
User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Robert Haas <robertmhaas@gmail.com>
CC: Tom Lane <tgl@sss.pgh.pa.us>, Richard Huxton <dev@archonet.com>,
	pgsql-performance@postgresql.org
Subject: Re: Need help with one query
References: <49C2AC75.5060601@collab.net> <49C3600E.20504@archonet.com>	
	<49C3CF52.9090602@collab.net>	
	<603c8f070903201204s53f2a3cvbf9afc8649b2201a@mail.gmail.com>	
	<12521.1237595840@sss.pgh.pa.us> <49C7C22B.9050003@collab.net>
	<603c8f070903231015h417f759cqd4519d24aefa6b5d@mail.gmail.com>
In-Reply-To: <603c8f070903231015h417f759cqd4519d24aefa6b5d@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-OriginalArrivalTime: 23 Mar 2009 19:56:21.0041 (UTC)
	FILETIME=[6FF2A210:01C9ABF1]
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200903/333
X-Sequence-Number: 33255

Robert Haas wrote:

>On Mon, Mar 23, 2009 at 1:08 PM, Anne Rosset <arosset@collab.net> wrote:
>  
>
>>enable_nestloop = off
>>    
>>
>
>That may be the source of your problem.  Generally setting enable_* to
>off is a debugging tool, not something you ever want to do in
>production.
>
>...Robert
>  
>
Thanks Robert. It seems to have solved the problem. Thanks a lot,

Anne