From: | tgl(at)postgresql(dot)org (Tom Lane) |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql: Fix regex_fixed_prefix() to cope reasonably well with regex |
Date: | 2007-01-03 22:39:49 |
Message-ID: | 20070103223949.E99F99FA48A@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Log Message:
-----------
Fix regex_fixed_prefix() to cope reasonably well with regex patterns of the
form '^(foo)$'. Before, these could never be optimized into indexscans.
The recent changes to make psql and pg_dump generate such patterns (for \d
commands and -t and related switches, respectively) therefore represented
a big performance hit for people with large pg_class catalogs, as seen in
recent gripe from Erik Jones. While at it, be more paranoid about
case-sensitivity checking in multibyte encodings, and fix some other
corner cases in which a regex might be interpreted too liberally.
Tags:
----
REL8_0_STABLE
Modified Files:
--------------
pgsql/src/backend/utils/adt:
regexp.c (r1.56.4.1 -> r1.56.4.2)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/regexp.c.diff?r1=1.56.4.1&r2=1.56.4.2)
selfuncs.c (r1.169.4.5 -> r1.169.4.6)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/selfuncs.c.diff?r1=1.169.4.5&r2=1.169.4.6)
pgsql/src/include/utils:
builtins.h (r1.252 -> r1.252.4.1)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/builtins.h.diff?r1=1.252&r2=1.252.4.1)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-01-03 22:39:57 | pgsql: Fix regex_fixed_prefix() to cope reasonably well with regex |
Previous Message | Tom Lane | 2007-01-03 22:39:42 | pgsql: Fix regex_fixed_prefix() to cope reasonably well with regex |