I wrote:
> On a longer-term basis, I'm looking into what we could do with
> extracting stats from subqueries, but that doesn't seem like material
> for a backpatch.  I have a draft patch that I've been playing with
> (attached).

I've committed a heavily rewritten version of that patch.  Git HEAD
seems to do reasonably well on the test case you gave at the start of
this thread.  I'm not sure yet how well the logic will hold up in
real-world queries as opposed to simplified test cases, but give it
a try.

			regards, tom lane

In response to

• Re: limit in subquery causes poor selectivity estimation at 2011-09-02 16:45:19 from Tom Lane

pgsql-hackers by date

Next:	From: Shigeru Hanada	Date: 2011-09-05 05:55:55
	Subject: Re: force_not_null option support for file_fdw
Previous:	From: Kohei KaiGai	Date: 2011-09-04 18:55:21
	Subject: Re: force_not_null option support for file_fdw