| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | pgsql-committers(at)postgresql(dot)org |
| Subject: | pgsql: Avoid detoast in texteq/textne/byteaeq/byteane for unequal-lengt |
| Date: | 2011-01-18 19:12:41 |
| Message-ID: | E1PfGyv-0000iA-7D@gemulon.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
Avoid detoast in texteq/textne/byteaeq/byteane for unequal-length strings.
We can get the length of a compressed or out-of-line datum without actually
detoasting it. If the lengths of two strings are unequal, we can then
conclude they are unequal without detoasting. That saves considerable work
in an admittedly less-common case, without costing anything much when the
optimization doesn't apply.
Noah Misch
Branch
------
master
Details
-------
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=1b393f4e5db4fd6bbc86a4e88785b6945a1541d0
Modified Files
--------------
src/backend/utils/adt/varlena.c | 116 +++++++++++++++++++++++++--------------
1 files changed, 75 insertions(+), 41 deletions(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2011-01-18 20:53:57 | pgsql: In test_fsync, adjust test headings to match wal_sync_method val |
| Previous Message | Magnus Hagander | 2011-01-18 19:04:05 | pgsql: Log replication connections only when log_connections is on |