HI,
we have a schema related question. We have 10 types of resource records.
Each one of these resource records has 3 fields (attributes) (lets say f1, f2, f3)...these fields have similar meaning
tothe corresponding 3 fields
in each resource record although they be named slightly differently in
each resource record type.
We want to view these 10 resource record types uniformly with respect to
these 3 fields and place indexes across all the types on each one of these
fields, so that all resource records regardless of type would appear in these indexes.
We want these indexes to be stored persistently in the physical database
because we have 10 million objects and it is not practical to keep
recreating the indexes every time we need them.
Is there some way to accomplish this in PostgreSQL?
thanks