Re: subquery plan rows = 1, but it's merge joined instead of index lookup

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: subquery plan rows = 1, but it's merge joined instead of index lookup
Дата
Msg-id 1a9f049f436b01ef2ad3ed0e283c50e54be8f4e9.camel@cybertec.at
обсуждение исходный текст
Ответ на [MASSMAIL] subquery plan rows = 1, but it's merge joined instead of index lookup  (ilya Basin <basinilya@gmail.com>)
Ответы Re: subquery plan rows = 1, but it's merge joined instead of index lookup  (Ilya Basin <basinilya@gmail.com>)
Список pgsql-general
Дерево обсуждения 
On Thu, 2024-04-11 at 15:57 +0300, ilya Basin wrote:
> Is there some complexity limit after which the planner starts acting dumb?

Yes, "join_collapse_limit" and "from_collapse_limit".
You can try increasing them.

Yours,
Laurenz Albe

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: (When) can a single SQL statement return multiple result sets?
Следующее
От: veem v
Дата:
Сообщение: [MASSMAIL]Question on trigger