Re: BUG #5885: Strange rows estimation for left join - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5885: Strange rows estimation for left join
Date
Msg-id 27062.1297740451@sss.pgh.pa.us
Whole thread Raw
In response to BUG #5885: Strange rows estimation for left join  ("Maxim Boguk" <Maxim.Boguk@gmail.com>)
Responses Re: BUG #5885: Strange rows estimation for left join  (Maxim Boguk <maxim.boguk@gmail.com>)
List pgsql-bugs
"Maxim Boguk" <Maxim.Boguk@gmail.com> writes:
> I found that strange effect while helping with slow query on russian
> postgresql online forum.

Please try to put together a self-contained test case for this.
I could not reproduce such a weird result here, but that probably
just means there's something strange about your data distribution.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Mike Fowler
Date:
Subject: Re: BUG #5859: XML result in line and column
Next
From: Vegard Bønes
Date:
Subject: Re: BUG #5883: Error when mixing SPI_returntuple with returning regular HeapTuple