| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Magnus Hagander <magnus(at)hagander(dot)net>, Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com>, Andy Colson <andy(at)squeakycode(dot)net>, Noah Misch <noah(at)leadboat(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: texteq/byteaeq: avoid detoast [REVIEW] |
| Date: | 2011-01-18 04:18:55 |
| Message-ID: | 1295324335.12898.8.camel@vanquo.pezone.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On mån, 2011-01-17 at 15:33 -0500, Tom Lane wrote:
> Peter Eisentraut <peter_e(at)gmx(dot)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.
Since citext exists and supports hashing, it's obviously possible
nevertheless.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2011-01-18 04:48:43 | Re: SSI patch version 12 |
| Previous Message | Jim Nasby | 2011-01-18 03:45:31 | Re: limiting hint bit I/O |