Alberto Dalmaso <dalmaso@xxxxxxxxxx> wrote: > Il giorno mar, 16/06/2009 alle 15.58 +0100, Matthew Wakeling ha > scritto: >> On Tue, 16 Jun 2009, Alberto Dalmaso wrote: >> > 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. These really are meant primarily for diagnostic purposes. As a last resort, you could set them off right before running a problem query, and set them back on again afterward; but you will be much better off if you can cure the underlying problem. The best chance of that is to show us the plan you get with all turned on. -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
