Lenard, Rohan (Rohan) wrote:
Actually the indexes on the child table do seem to get used - I just
wanted to make sure there was no penalty not having indexes on the
empty parent tables.
You are right - the parent is the best way to get at the unknown
children ...
Indexes are created in the inheritance process, iirc. However, index
entries are not inherited, which means that index-based unique
constraints don't properly get inherited.
Best Wishes,
Chris Travers
Metatron Technology Consulting
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
