Re: Slow query, where am I going wrong?

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: Slow query, where am I going wrong?
Дата
Msg-id D960CB61B694CF459DCFB4B0128514C2089A62C4@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?
Список pgsql-performance
AndyG wrote:
> A marginal improvement.
>
> http://explain.depesz.com/s/y63

That's what I thought.

Increasing the statistics for test_result.id_recipe_version
had no effect?

> I am going to normalize the table some more before partitioning.

How do you think that partitioning will help?

Yours,
Laurenz Albe


В списке pgsql-performance по дате отправления:

Предыдущее
От: Maciek Sakrejda
Дата:
Сообщение: Re: PostgreSQL server failed to start
Следующее
От: Vincenzo Melandri
Дата:
Сообщение: Re: Seq scan on 10million record table.. why?