Postgres Professional
   

Re: Need help with one query

From: Anne Rosset
Subject: Re: Need help with one query
Date: ,
Msg-id: 49C7E95B.3050502@collab.net
(view: Whole thread, Raw)
In response to: Re: Need help with one query  (Robert Haas)
List: pgsql-performance

Tree view

Need help with one query  (Anne Rosset, )
 Re: Need help with one query  (Richard Huxton, )
  Re: Need help with one query  (Tom Lane, )
  Re: Need help with one query  (Anne Rosset, )
   Re: Need help with one query  (Robert Haas, )
    Re: Need help with one query  (Alvaro Herrera, )
     Re: Need help with one query  (Anne Rosset, )
      Re: Need help with one query  (Robert Haas, )
    Re: Need help with one query  (Tom Lane, )
     Re: Need help with one query  (Anne Rosset, )
      Re: Need help with one query  (Robert Haas, )
       Re: Need help with one query  (Anne Rosset, ) 
Robert Haas wrote:

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

pgsql-performance by date:

Previous:
From: Sergey Burladyan
Date:
Subject: Why creating GIN table index is so slow than inserting data into empty table with the same index?
Next:
From: Tom Lane
Date:
Subject: Re: Why creating GIN table index is so slow than inserting data into empty table with the same index?