Was partitioned table row estimation fixed in 9.0?
in [PgSql]
|
Prev: [HACKERS] Was partitioned table row estimation fixed in 9.0?
Next: Testing of parallel restore with currentsnapshot
From: Tom Lane on 26 Feb 2010 22:00 Josh Berkus <josh(a)agliodbs.com> writes: > There were a flurry of patches around this from Stark and Aster Data, so > I'm checking if I should be testing on 9.0 or adding this to the TODO list. > The problem I'm grappling with is that OUTER JOINS against the master in > a partitioned table (joining to the append node) gives a row estimate > which does not take into account any CE applicable to the partitioned > table. The CE is properly executed when the join is actually executed, > but with the row estimate way off (orders of magnitude) you often get > bad plans for other joins in the query. Would you give a concrete example? There was some work done in this area but it's impossible to tell whether it solves your problem with only that much detail. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers |