Re: Problem with planner - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: Problem with planner
Date
Msg-id 20110809172332.GA22789@depesz.com
Whole thread Raw
In response to Re: Problem with planner  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Tue, Aug 09, 2011 at 12:11:48PM -0400, Tom Lane wrote:
> Now part of the reason why the estimate is so bad is the sub-select,
> which completely defeats selectivity estimation for the ending_tsz
> condition.  Could we see EXPLAIN ANALYZE for the query without a
> sub-select, both with and without enable_bitmapscan?

working on it.

Best regards,

depesz

--
The best thing about modern society is how easy it is to avoid contact with it.
                                                             http://depesz.com/

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Update with ORDER BY and LIMIT
Next
From: Adrian Klaver
Date:
Subject: Re: postgresql server crash on windows 7 when using plpython