"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])

Reply via email to