"Lada 'Ray' Lostak" <ray@unreal64.net> writes:
> I don't understand why following '3' statements are SOO different. We
> run latest PgSQL, OpenBSD 3.4, AMD XP 2000+ and plenty of RAM... CPU was
> fully dedicated to PG.
Define "latest PgSQL". The query plans look like 7.3 or older results
to me. 7.4 should do the IN with a hash join ...
regards, tom lane