Tom, I'm using 8.3.1. I did run EXPLAIN but have never familiarized myself with how to read/use it beside simple comparing cost estimation and whether there is any seq scan that can benefit from creating index.
Thanks for replying On Jun 7, 11:19 am, [EMAIL PROTECTED] (Tom Lane) wrote: > askel <[EMAIL PROTECTED]> writes: > > Performance is at least few times better when EXISTS is used. > > It really shouldn't be. PG knows more possible plans for IN than > EXISTS, so IN should pretty much always be equal or better ... unless > the planner is making the wrong choice. I speculate that you have > out-of-date statistics or some such. Have you compared EXPLAIN ANALYZE > output for the two cases? Which PG version are we talking about? > > regards, tom lane > > -- > Sent via pgsql-general mailing list ([EMAIL PROTECTED]) > To make changes to your > subscription:http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
