Re: POSIX regex performance bug in 7.3 Vs. 7.2 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: POSIX regex performance bug in 7.3 Vs. 7.2
Date
Msg-id 2603.1044331694@sss.pgh.pa.us
Whole thread Raw
In response to Re: POSIX regex performance bug in 7.3 Vs. 7.2  (wade <wade@wavefire.com>)
List pgsql-hackers
Next question: may I guess that you weren't using MULTIBYTE in 7.2?

After still more digging, I'm coming round to the opinion that the
problem is that MULTIBYTE is forced on in 7.3, and this imposes a
factor-of-256 overhead in a bunch of the operations in regcomp.c.
In particular, compiling a case-independent regex is now hugely
more expensive than it used to be.

The parties who wanted to force MULTIBYTE on promised that there 
would be no such penalties :-(
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: POSIX regex performance bug in 7.3 Vs. 7.2
Next
From: Tom Lane
Date:
Subject: Re: regression failure on freebsd/alpha