On Mon, Jan 17, 2011 at 04:05, Andy Colson <a...@squeakycode.net> wrote: > This is a review of: > https://commitfest.postgresql.org/action/patch_view?id=468 > > Purpose: > ======== > Equal and not-equal _may_ be quickly determined if their lengths are > different. This _may_ be a huge speed up if we don't have to detoast.
We can skip detoast to compare lengths of two text/bytea values with the patch, but we still need detoast to compare the contents of the values. If we always generate same toasted byte sequences from the same raw values, we don't need to detoast at all to compare the contents. Is it possible or not? -- Itagaki Takahiro -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
