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-30 15:48:56
Message-ID: D960CB61B694CF459DCFB4B0128514C2089A62C4@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Daniel Burbridge 2012-10-30 16:41:49 Re: Prepared statements slow in 9.2 still (bad query plan)
Previous Message Maciek Sakrejda 2012-10-30 15:43:27 Re: PostgreSQL server failed to start