Re: Slow query, where am I going wrong?

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: Slow query, where am I going wrong?
Дата
Msg-id D960CB61B694CF459DCFB4B0128514C208A4E205@exadv11.host.magwien.gv.at
обсуждение исходный текст
Ответ на Re: Slow query, where am I going wrong?  (AndyG <andy.gumbrecht@orprovision.com>)
Ответы Re: Slow query, where am I going wrong?  (AndyG <andy.gumbrecht@orprovision.com>)
Список 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 по дате отправления:

Предыдущее
От: AndyG
Дата:
Сообщение: Re: Slow query, where am I going wrong?
Следующее
От: AndyG
Дата:
Сообщение: Re: Slow query, where am I going wrong?