Re: Planner matching constants across tables in a

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Planner matching constants across tables in a
Дата
Msg-id web-2881474@davinci.ethosmedia.com
обсуждение исходный текст
Ответ на Re: Planner matching constants across tables in a join  (Richard Huxton <dev@archonet.com>)
Ответы Re: Planner matching constants across tables in a
Re: Planner matching constants across tables in a
Список pgsql-performance
Richard,

> A domain defined as varchar() actually - which is why it's not using
> an index,
> but that's neither here nor there regarding the constant issue.

You might improve your performance overall if you cast the constant to
tel_num before doing the comparison in the query.   Right now, the
parser is casting the whole column to text instead, because it can't
tell that the constant you supply is a valid tel_num.

-Josh

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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Planner matching constants across tables in a join
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Planner matching constants across tables in a