Skip site navigation (1) Skip section navigation (2)

Re: Really dumb planner decision

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Matthew Wakeling <matthew(at)flymine(dot)org>, gryzman(at)gmail(dot)com, Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Really dumb planner decision
Date: 2009-04-16 14:44:03
Message-ID: b42b73150904160744lf4b93f4j6bb8c44b8322e31@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Thu, Apr 16, 2009 at 10:11 AM, Kevin Grittner
<Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> Bear in mind that those limits exist to keep you from running into
>> exponentially increasing planning time when the size of a planning
>> problem gets big.  "Raise 'em to the moon" isn't really a sane
> strategy.
>> It might be that we could get away with raising them by one or two
> given
>> the general improvement in hardware since the values were last
> looked
>> at; but I'd be hesitant to push the defaults further than that.
>
> I also think that there was a change somewhere in the 8.2 or 8.3 time
> frame which mitigated this.  (Perhaps a change in how statistics were
> scanned?)  The combination of a large statistics target and higher
> limits used to drive plan time through the roof, but I'm now seeing
> plan times around 50 ms for limits of 20 and statistics targets of
> 100.  Given the savings from the better plans, it's worth it, at least
> in our case.
>
> I wonder what sort of testing would be required to determine a safe
> installation default with the current code.

Well, given all the variables, maybe we should instead bet targeting
plan time, either indirectly vi estimated values, or directly by
allowing a configurable planning timeout, jumping off to alternate
approach (nestloopy style, or geqo) if available.

merlin

In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2009-04-16 15:36:34
Subject: Re: Shouldn't the planner have a higher cost for reverse index scans?
Previous:From: Kevin GrittnerDate: 2009-04-16 14:11:14
Subject: Re: Really dumb planner decision

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group