From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Peter Eisentraut <peter_e(at)gmx(dot)net>
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-17 20:33:57
Message-ID:
20235.1295296437@sss.pgh.pa.us (view raw or flat )
Thread:
2010-12-20 18:19:53 from Noah Misch <noah(at)leadboat(dot)com>
2011-01-04 03:23:03 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-01-04 13:46:29 from Noah Misch <noah(at)leadboat(dot)com>
2011-01-04 14:13:11 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2011-01-04 14:23:40 from Noah Misch <noah(at)leadboat(dot)com>
2011-01-16 19:05:11 from Andy Colson <andy(at)squeakycode(dot)net>
2011-01-16 21:07:13 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2011-01-16 22:47:38 from Noah Misch <noah(at)leadboat(dot)com>
2011-01-16 23:44:37 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2011-01-16 22:23:39 from Noah Misch <noah(at)leadboat(dot)com>
2011-01-17 05:51:59 from Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com>
2011-01-17 06:22:40 from KaiGai Kohei <kaigai(at)ak(dot)jp(dot)nec(dot)com>
2011-01-17 08:13:29 from Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com>
2011-01-17 10:05:09 from Magnus Hagander <magnus(at)hagander(dot)net>
2011-01-17 15:28:27 from Noah Misch <noah(at)leadboat(dot)com>
2011-01-17 20:39:56 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-01-18 08:06:24 from Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com>
2011-01-18 16:15:02 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-01-18 16:32:10 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-01-18 16:44:16 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-01-18 16:45:05 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-01-18 16:53:07 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-01-17 06:35:52 from Magnus Hagander <magnus(at)hagander(dot)net>
2011-01-17 07:13:28 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2011-01-17 07:51:56 from Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com>
2011-01-17 07:56:38 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2011-01-17 07:56:18 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2011-01-17 12:55:15 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-01-17 19:12:57 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2011-01-17 20:33:57 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-01-18 04:18:55 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2011-01-18 08:03:01 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2011-01-19 08:22:41 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2011-01-17 15:22:51 from Noah Misch <noah(at)leadboat(dot)com>
2011-01-17 20:36:56 from Jim Nasby <jim(at)nasby(dot)net>
2011-01-17 21:13:12 from Noah Misch <noah(at)leadboat(dot)com>
2011-01-18 19:13:15 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Lists:
pgsql-hackers
Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> On mn, 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
In response to
Responses
pgsql-hackers by date
Next :From: Jim NasbyDate: 2011-01-17 20:36:56Subject : Re: texteq/byteaeq: avoid detoast [REVIEW]Previous :From : Simon RiggsDate : 2011-01-17 20:24:30Subject : Re: We need to log aborted autovacuums
