Josh Sacks <[EMAIL PROTECTED]> writes:
> I can't understand what's going on in this simple query:

If you are using anything older than PG 7.4, you should not expect good
performance from WHERE ... IN (sub-SELECT) queries.  There's essentially
no optimization happening there.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

Reply via email to