Re: performance with query

Alberto Dalmaso <dalmaso@clesius.it> writes:
> Il giorno mar, 16/06/2009 alle 15.58 +0100, Matthew Wakeling ha scritto:
>>> enable_hashjoin = off
>>> enable_nestloop = off
>>> enable_seqscan = off
>>> enable_sort = off
>>
>> Why are these switched off?
>>
> because of the need to pump up the performance of the complex query.

That is *not* the way to improve performance of a query.  Turning off
specific enable_ parameters can be helpful while investigating planner
behavior, but it is never recommended as a production solution.  You
have already found out why.

            regards, tom lane