"Ed L." <pgsql@bluepolka.net> writes:
> create view big_view as
> select *, 'big_table'::varchar as source from big_table
> union
> select *, 'small_table'::varchar as source from small_table;
Try "UNION ALL" instead of just "union"
The difference is that union has to avoid duplicates. If you want duplicates
to be included or know for certain there will be no duplicates then union all
is faster.
--
greg