"Lada 'Ray' Lostak" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])