Mike Friesen <mfriesen(at)pmcanada(dot)com> writes:
> select * from icpr,iprc where icpr.prod_no='23' AND
> icpr.prod_no=iprc.prod_no;
> Can anyone tell me what I'm doing wrong?
Probably you're getting a poor plan for the query (likely, it's
using a nested loop). Have you done VACUUM ANALYZE lately for
these tables? If so, what does EXPLAIN show for the query?
regards, tom lane