Re: Bogus nestloop rows estimate in 8.4.7 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Bogus nestloop rows estimate in 8.4.7
Date
Msg-id 9486.1338227815@sss.pgh.pa.us
Whole thread Raw
In response to Bogus nestloop rows estimate in 8.4.7  (Marti Raudsepp <marti@juffo.org>)
Responses Re: Bogus nestloop rows estimate in 8.4.7
List pgsql-hackers
Marti Raudsepp <marti@juffo.org> writes:
> This bug isn't causing me any immediate problems -- the plan works out
> well regardless -- but PostgreSQL 8.4.7 is somehow overestimating the
> number of rows coming from a nestloop join, when joining 2 large
> partitioned tables.

This sounds familiar, but a quick trawl through the commit logs didn't
immediately turn up any related-looking patches.  Can you put together
a self-contained test case?

Also, what do you have constraint_exclusion set to?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: How could we make it simple to access the log as a table?
Next
From: Christopher Browne
Date:
Subject: Re: How could we make it simple to access the log as a table?