Alberto Dalmaso <dalmaso@xxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
