> I have tried creating an index for manu_base using the following commands:
> create index manu_mid_idx on "manu_base" using btree ("mid" "int2_ops");
> drop index manu_mid_idx
> create index manu_mid_idx on "manu_base" using hash ("mid" "int2_ops");
> drop index manu_mid_idx
You should also try out defining indices on prod_base.
The most efficient way for joining is an "merge join" this requires an
BTREE-index on both fields to be joined.
If EXPLAIN does not show index-usage you should do a VACUUM on both
tables to update statistics.
Elmar