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: ---- REL7_4_STABLE Modified Files: -------------- pgsql/src/backend/utils/adt: regexp.c (r1.49.4.3 -> r1.49.4.4) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/regexp.c.diff?r1=1.49.4.3&r2=1.49.4.4) selfuncs.c (r1.147.2.4 -> r1.147.2.5) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/selfuncs.c.diff?r1=1.147.2.4&r2=1.147.2.5) pgsql/src/include/utils: builtins.h (r1.228.2.1 -> r1.228.2.2) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/builtins.h.diff?r1=1.228.2.1&r2=1.228.2.2)
pgsql-committers by date:
Соглашаюсь с условиями обработки персональных данных