Re: Not using Primary Key in query

Josh Sacks <josh.sacks@gmail.com> 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