Re: texteq/byteaeq: avoid detoast [REVIEW] - Mailing list pgsql-hackers

From Tom Lane
Subject Re: texteq/byteaeq: avoid detoast [REVIEW]
Date
Msg-id 20235.1295296437@sss.pgh.pa.us
Whole thread Raw
In response to Re: texteq/byteaeq: avoid detoast [REVIEW]  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: texteq/byteaeq: avoid detoast [REVIEW]  (Peter Eisentraut <peter_e@gmx.net>)
Re: texteq/byteaeq: avoid detoast [REVIEW]  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List 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 by date:

Previous
From: Simon Riggs
Date:
Subject: Re: We need to log aborted autovacuums
Next
From: Jim Nasby
Date:
Subject: Re: texteq/byteaeq: avoid detoast [REVIEW]