Franck Routier <franck.routier@xxxxxxxxx> wrote: > So I wanted to better understand to what extend using a > sledgehammer will impact me :-) Disabling it globally is likely to significantly hurt some queries. Before resorting to that, you might decrease effective_cache_size, increase random_page_cost, and (most importantly) do whatever you can to improve statistics. Where those fail, and disabling nested loops helps, I concur with the advice to only do that for specific queries, taking care to reset it afterward. In other words, use that sledgehammer with great care, don't just swing it around wildly.... ;-) -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
