Re: Subquery WHERE IN or WHERE EXISTS faster?

От: Tom Lane
Тема: Re: Subquery WHERE IN or WHERE EXISTS faster?
Дата: ,
Msg-id: 11687.1214801324@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: Re: Subquery WHERE IN or WHERE EXISTS faster?  ("Jaime Casanova")
Список: pgsql-performance

Скрыть дерево обсуждения

Subquery WHERE IN or WHERE EXISTS faster?  (Ulrich, )
 Re: Subquery WHERE IN or WHERE EXISTS faster?  (Tom Lane, )
  Re: Subquery WHERE IN or WHERE EXISTS faster?  (Ulrich, )
   Re: Subquery WHERE IN or WHERE EXISTS faster?  (Gregory Stark, )
    Re: Subquery WHERE IN or WHERE EXISTS faster?  (Ulrich, )
     Re: Subquery WHERE IN or WHERE EXISTS faster?  (Gregory Stark, )
   Re: Subquery WHERE IN or WHERE EXISTS faster?  (Rusty Conover, )
    Re: Subquery WHERE IN or WHERE EXISTS faster?  (Ulrich, )
     Re: Subquery WHERE IN or WHERE EXISTS faster?  (Rusty Conover, )
      Re: Subquery WHERE IN or WHERE EXISTS faster?  ("Sergio Gabriel Rodriguez", )
   Re: Subquery WHERE IN or WHERE EXISTS faster?  ("Sergio Gabriel Rodriguez", )
  Re: Subquery WHERE IN or WHERE EXISTS faster?  ("Jaime Casanova", )
   Re: Subquery WHERE IN or WHERE EXISTS faster?  (Tom Lane, )

"Jaime Casanova" <> writes:
> i've made some queries run faster using EXISTS instead of large IN
> clauses... actually, it was NOT EXISTS replacing a NOT IN

That's just about entirely unrelated ...

            regards, tom lane


В списке pgsql-performance по дате сообщения:

От: Dimitri Fontaine
Дата:
Сообщение: Re: Planner should use index on a LIKE 'foo%' query
От: John Beaver
Дата:
Сообщение: Re: sequence scan problem