Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group