"NOT IN" predicate hangs result - Mailing list pgsql-general

Hi all,
   I recently tried this select statement and it hung my tool:

1)   select count(*) from user_profile where address_id not in (select address_id from address);

Originally, I just thought that it was slow, so I left it over night and when I can back the next morning it
just hung there(eating up CPU cycles). I looked in Celko's book and then tried this and it worked(quite fast):

2)   select count(*) from user_profile up where not exists (select * from address addr where up.address_id =
addr.address_id);

Is this a known problem?

Thanks
Rick