Florian Weimer <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
