Re: Poor plan when using EXISTS in the expression list

Поиск
Список
Период
Сортировка
От Geoff Winkless
Тема Re: Poor plan when using EXISTS in the expression list
Дата
Msg-id CAEzk6fdLWr+RGQN0D+L50oeTj8hvM4s3HJ1Q4StGYHCQXXUeUg@mail.gmail.com
обсуждение исходный текст
Ответ на Poor plan when using EXISTS in the expression list  (Pierre Ducroquet <p.psql@pinaraf.info>)
Ответы Re: Poor plan when using EXISTS in the expression list
Список pgsql-hackers
On Thu, 4 Oct 2018 at 13:11, Pierre Ducroquet <p.psql@pinaraf.info> wrote:
Our developpers ORM (Django's) sadly can not use EXISTS in the where clauses
without having it in the expression part of the SELECT statement.
 
I don't know if this will be helpful to you (and I appreciate there's still the underlying PG issue), but there's a suggestion here that you can work around this using .extra()


Geoff

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: executor relation handling
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Multiple primary key on partition table?