Re: A question on the query planner

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: A question on the query planner
Дата
Msg-id 25476.1070409047@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: A question on the query planner  (Greg Stark <gsstark@mit.edu>)
Ответы Re: A question on the query planner  (Greg Stark <gsstark@mit.edu>)
Список pgsql-performance
Greg Stark <gsstark@mit.edu> writes:
> Huh. The following shows something strange. It seems joining on two varchars
> no longer works well. Instead the optimizer has to convert both columns to
> text.

Define "no longer works well".  varchar doesn't have its own comparison
operators anymore, but AFAIK that makes no difference.

            regards, tom lane

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

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: cross table indexes or something?
Следующее
От: Greg Stark
Дата:
Сообщение: Re: A question on the query planner