Re: Any better plan for this query?.. - Mailing list pgsql-performance

From Simon Riggs
Subject Re: Any better plan for this query?..
Date
Msg-id 1242068608.3843.161.camel@ebony.2ndQuadrant
Whole thread Raw
In response to Re: Any better plan for this query?..  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
On Mon, 2009-05-11 at 11:23 -0400, Tom Lane wrote:
> Dimitri <dimitrik.fr@gmail.com> writes:
> > Anyone may explain me why analyze target may have so huge negative
> > secondary effect?..
>
> If these are simple queries, maybe what you're looking at is the
> increase in planning time caused by having to process 10x as much
> statistical data.  Cranking statistics_target to the max just because
> you can is not necessarily a good strategy.

statistics_target effects tables, so we have problems if you have a mix
of simple and complex queries. IMHO we need an explicit planner_effort
control, rather than the more arcane *_limit knobs which are effectively
the same thing, just harder to use in practice.

--
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support


pgsql-performance by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Any better plan for this query?..
Next
From: Aidan Van Dyk
Date:
Subject: Re: Any better plan for this query?..