Alberto Dalmaso <dalmaso(at)clesius(dot)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