pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Anne Rosset <arosset@collab.net>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Richard Huxton <dev@archonet.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Need help with one query
Date: Mon, 23 Mar 2009 12:56:11 -0700
Message-ID: <49C7E95B.3050502@collab.net> (raw)
In-Reply-To: <603c8f070903231015h417f759cqd4519d24aefa6b5d@mail.gmail.com>
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>

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

view thread (12+ messages)

Message-ID: <49C7E95B.3050502@collab.net>
Permalink:  ../49C7E95B.3050502@collab.net/
Also on:    postgresql.org/message-id/49C7E95B.3050502@collab.net

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: arosset@collab.net, robertmhaas@gmail.com, tgl@sss.pgh.pa.us, dev@archonet.com
  Subject: Re: Need help with one query
  In-Reply-To: <49C7E95B.3050502@collab.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox