Florian Weimer <fweimer@bfk.de> 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