Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #14404: High row estimates when query uses master inherited tables - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #14404: High row estimates when query uses master inherited tables
Date
Msg-id 11482.1478112324@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #14404: High row estimates when query uses master inherited tables  (Clinton Adams <clinton.adams@gmail.com>)
Responses Re: BUG #14404: High row estimates when query uses master inherited tables
List pgsql-bugs
Tree view 
Clinton Adams <clinton.adams@gmail.com> writes:
> -- Dropping the fkey causes the first query to show a much better row
> estimate, in line with 9.4 and 9.5 plans.

Ah.  So this must be something to do with the foreign-key-driven rowcount
estimates we added in 9.6.  Will look into it, thanks for the report!

            regards, tom lane

pgsql-bugs by date:

Previous
From: Clinton Adams
Date:
Subject: Re: BUG #14404: High row estimates when query uses master inherited tables
Next
From: Tom Lane
Date:
Subject: Re: BUG #14404: High row estimates when query uses master inherited tables