At 10:52 PM 1/31/03 -0500, Tom Lane wrote: >wade <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster