Re: Slow query, where am I going wrong? - Mailing list pgsql-performance

From Albe Laurenz
Subject Re: Slow query, where am I going wrong?
Date
Msg-id D960CB61B694CF459DCFB4B0128514C208A4E205@exadv11.host.magwien.gv.at
Whole thread Raw
In response to Re: Slow query, where am I going wrong?  (AndyG <andy.gumbrecht@orprovision.com>)
Responses Re: Slow query, where am I going wrong?  (AndyG <andy.gumbrecht@orprovision.com>)
List pgsql-performance
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


pgsql-performance by date:

Previous
From: AndyG
Date:
Subject: Re: Slow query, where am I going wrong?
Next
From: AndyG
Date:
Subject: Re: Slow query, where am I going wrong?