Re: PG choosing nested loop for set membership?

Поиск
Список
Период
Сортировка
От Brian Crowell
Тема Re: PG choosing nested loop for set membership?
Дата
Msg-id CAAQkdDoaUB5JfN4SgKqWbhwXGXeb6BmaQxLNibXAYxnbgtwe_Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PG choosing nested loop for set membership?  (David Johnston <polobo@yahoo.com>)
Список pgsql-general
On Tue, Mar 25, 2014 at 4:12 PM, David Johnston <polobo@yahoo.com> wrote:
> 2 - and the one I'd use by default) Use an INNER JOIN

That's where I started, but Postgres is smart enough to know that this
is equivalent to what I'm doing, and still picks the nested loop. I
went to IN in the hopes of tricking it.

I haven't tried EXISTS. I'll have to try that tomorrow.

--Brian


В списке pgsql-general по дате отправления:

Предыдущее
От: Brian Crowell
Дата:
Сообщение: Re: PG choosing nested loop for set membership?
Следующее
От: John Smith
Дата:
Сообщение: Re: tsearch2: how to plainto_tsquery() with "|"