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 29426.1477704022@sss.pgh.pa.us
Whole thread Raw
In response to BUG #14404: High row estimates when query uses master inherited tables  (clinton.adams@gmail.com)
Responses Re: BUG #14404: High row estimates when query uses master inherited tables
List pgsql-bugs
clinton.adams@gmail.com writes:
> Row estimates are way off (406484054678631 vs 38) when using master
> partition tables. If I change the query to go directly against one child
> table, estimates and query time are in line with what I expect.

Those EXPLAINs do look kinda fishy, but with only this much information,
it's unlikely that anyone is going to be able to guess why.  A
self-contained example would be much more useful.

            regards, tom lane

pgsql-bugs by date:

Previous
From: clinton.adams@gmail.com
Date:
Subject: BUG #14404: High row estimates when query uses master inherited tables
Next
From: dv
Date:
Subject: ORDER BY TABLENAME, possible bug