Florian Weimer <fweimer@xxxxxx> writes: > I'm going to create a (manually) partioned table and wonder whether I > should use inherited tables or an explicitly created view using UNION > ALL. Constraint exclusion is not important for this application > (major updates will directly target the individual tables). IIRC, these should be planned equivalently in 8.2, but they go through different planner paths in 8.1 and before --- you'll want to check the specific queries you have in mind and see whether they get planned as you want. C-E definitely only works on the inheritance case in 8.1. regards, tom lane
