"Kevin Grittner" <Kevin.Grittner@xxxxxxxxxxxx> writes: > Craig Ringer <craig@xxxxxxxxxxxxxxxxxxxxx> wrote: >> Doesn't the planner have some ... issues ... with estimation of >> row counts on joins over unions? Or is my memory just more faulty >> than usual? > So far I can't tell if it's views with unions or (as I suspect) > inheritance. As of recent versions there shouldn't be a lot of difference between inheritance and UNION ALL subqueries --- they're both "appendrels" to the planner. And yeah, I think the statistical support is pretty crummy. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
