Re: Planner matching constants across tables in a join

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Planner matching constants across tables in a join
Дата
Msg-id 87llzt97ra.fsf@stark.dyndns.tv
обсуждение исходный текст
Ответ на Re: Planner matching constants across tables in a join  (Richard Huxton <dev@archonet.com>)
Ответы Re: Planner matching constants across tables in a join
Список pgsql-performance
Richard Huxton <dev@archonet.com> writes:

> Filter: ((line_id)::text = '0912345 0004'::text)

So I think this means that line_id is being casted to "text". Though I'm not
clear why it would be choosing "text" for the constant if line_id wasn't text
to begin with.

In any case my plans here look like:
> Filter: (aa = 'x'::text)

so it looks like there's something extra going on in your plan.

what does your table definition look like?

--
greg

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

Предыдущее
От: Rod Taylor
Дата:
Сообщение: Re: OIDs as keys
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Planner matching constants across tables in a join