Re: POSIX regex performance bug in 7.3 Vs. 7.2

At 10:52 PM 1/31/03 -0500, Tom Lane wrote:
>wade <wade@wavefire.com> writes:
>>   We recently upgraded a project from 7.2 to 7.3.1 to make use of some of
>> the cool new features in 7.3.  The installed version is CVS stable from
>> yesterday.  However, we noticed a major performance hit in POSIX regular
>> expression matches against columns using the ~* operator.  
>
>The only thought that comes to mind is that multibyte character sets are
>supported in 7.3 whereas they were optional (and not default) in 7.2.
>I'd not have expected a factor-of-150 performance hit from that, though.
>
>Could you rebuild your backend with profiling enabled and get a gprof
>summary of where the time is going?
>
>            regards, tom lane
>
>
Here is the profile information.  I included a log of the session that
generated it at the top of the gprof  output.  If there is any other info I
can help you with, please let me know.
http://arch.wavefire.com/pgregexgmon.txt
 -Wade Klaver