Re: Need help with one query

From: Anne Rosset <arosset(at)collab(dot)net>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Richard Huxton <dev(at)archonet(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Need help with one query
Date: 2009-03-23 19:56:11
Message-ID: 49C7E95B.3050502@collab.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Robert Haas wrote:

>On Mon, Mar 23, 2009 at 1:08 PM, Anne Rosset <arosset(at)collab(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2009-03-23 19:58:29 Re: multiple threads inserting into the same table
Previous Message David Wilson 2009-03-23 19:49:34 Re: multiple threads inserting into the same table