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 D960CB61B694CF459DCFB4B0128514C2089A62C4@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:
> 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 by date:

Previous
From: Maciek Sakrejda
Date:
Subject: Re: PostgreSQL server failed to start
Next
From: Vincenzo Melandri
Date:
Subject: Re: Seq scan on 10million record table.. why?