Re: Slow query, where am I going wrong?

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "AndyG *EXTERN*" <andy(dot)gumbrecht(at)orprovision(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Slow query, where am I going wrong?
Date: 2012-10-31 09:35:54
Message-ID: D960CB61B694CF459DCFB4B0128514C208A4E205@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message AndyG 2012-10-31 10:18:11 Re: Slow query, where am I going wrong?
Previous Message AndyG 2012-10-31 09:18:23 Re: Slow query, where am I going wrong?