| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | wade <wade(at)wavefire(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: POSIX regex performance bug in 7.3 Vs. 7.2 |
| Date: | 2003-02-01 03:52:53 |
| Message-ID: | 4007.1044071573@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
wade <wade(at)wavefire(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sean Chittenden | 2003-02-01 04:09:54 | Re: [PERFORM] not using index for select min(...) |
| Previous Message | Lamar Owen | 2003-02-01 03:49:32 | Re: [mail] Re: Windows Build System |