AndyG wrote: >> Increasing the statistics for test_result.id_recipe_version >> had no effect? > I increased the statistics in steps up to 5000 (with vacuum analyse) - Seems > to be as good as it gets. > > http://explain.depesz.com/s/z2a Just out of curiosity, do you get a better plan with enable_nestloop=off? Not that I think it would be a good idea to change that setting in general. Yours, Laurenz Albe -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
