> Hello everyone.
> We are facing a performance problem with views consisting of several
> unioned tables. The simplified schema is as follows:
>       foo_object_id   bigint,
>       link_id         bigint,
>       somedata        text,
>       PRIMARY KEY (foo_object_id) );

point 1:
well, you may want to consider:

create table foobar
        prefix            text, --  foo/bar/etc
      object_id       bigint,
        link_id         bigint,
        primary key(prefix, object_id)
); -- add indexes as appropriate

and push foo/bar specific information to satellite table which refer
back via pkey-key link.  Now you get very quick and easy link id query
and no view is necessary.  You also may want to look at table
inheritance but make sure you read all the disclaimers first.

point 2: 
watch out for union, it is implied sort and duplicate filter.  union all
is faster although you may get duplicates.


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to