Re: BUG #15857: Parallel Hash Join makes join instead of exists

Поиск
Список
Период
Сортировка
От Thomas Munro
Тема Re: BUG #15857: Parallel Hash Join makes join instead of exists
Дата
Msg-id CA+hUKGKcPcayiknzwx5BAo41cs-ymtLk6b8Ebg7fjXsVMvmcUQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #15857: Parallel Hash Join makes join instead of exists  (Thomas Munro <thomas.munro@gmail.com>)
Ответы Re: BUG #15857: Parallel Hash Join makes join instead of exists  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Дерево обсуждения 
On Tue, Jun 18, 2019 at 9:24 PM Thomas Munro <thomas.munro@gmail.com> wrote:
> That points to the problem: for JOIN_UNIQUE_INNER we plan a Parallel
> Hash Join, but that's nonsense, there is no code to unique-ify the
> partial inner side (because that's not possible).   There may be
> something better we can do here (like understanding that this should
> really be a semi-join), but this works for me to prevent the bad plan:

Here's a tidier version with a comment and commit message.

-- 
Thomas Munro
https://enterprisedb.com
Вложения

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

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15858: could not stat file - over 4GB
Следующее
От: Joao Ferreira
Дата:
Сообщение: Querying foreign table with SP-GiST index results in “ERROR: cache lookup failed for type 0”