Re: texteq/byteaeq: avoid detoast [REVIEW]

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: texteq/byteaeq: avoid detoast [REVIEW]
Дата
Msg-id 20235.1295296437@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: texteq/byteaeq: avoid detoast [REVIEW]  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: texteq/byteaeq: avoid detoast [REVIEW]  (Peter Eisentraut <peter_e@gmx.net>)
Re: texteq/byteaeq: avoid detoast [REVIEW]  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Список pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> On mån, 2011-01-17 at 07:35 +0100, Magnus Hagander wrote:
>> In fact, aren't there cases where the *length test* also fails?

> Currently, two text values are only equal of strcoll() considers them
> equal and the bits are the same.  So this patch is safe in that regard.

> There is, however, some desire to loosen this.

That isn't ever going to happen, unless you'd like to give up hash joins
and hash aggregation on text values.
        regards, tom lane


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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: We need to log aborted autovacuums
Следующее
От: Jim Nasby
Дата:
Сообщение: Re: texteq/byteaeq: avoid detoast [REVIEW]