| From: | wade <wade(at)wavefire(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
| Cc: | neilc(at)samurai(dot)com, jon(at)endpoint(dot)com, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: POSIX regex performance bug in 7.3 Vs. 7.2 |
| Date: | 2003-02-05 16:50:01 |
| Message-ID: | 3.0.32.20030205085000.02114350@mail.wavefire.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Confirmed. Looks like a 100-fold increase. Thanx guys.
Explain output can be seen here:
http://arch.wavefire.com/pgregex.txt
-Wade Klaver
At 09:59 AM 2/5/03 -0500, Tom Lane wrote:
>Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> writes:
>> Ok. The original complain can be sasily solved at least for single
>> byte encoding databases. With the small patches(against 7.3.1)
>> included, I got following result.
>
>Nice work, Tatsuo! Wade, can you confirm that this patch solves your
>problem?
>
>Tatsuo, please commit into REL7_3 branch only --- I'm nearly ready to do
>a wholesale replacement of the regex code in HEAD, so you wouldn't
>accomplish much except to create a merge problem for me ...
>
> regards, tom lane
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | D'Arcy J.M. Cain | 2003-02-05 17:06:16 | Re: PostgreSQL, NetBSD and NFS |
| Previous Message | Tom Lane | 2003-02-05 16:49:56 | Re: PostgreSQL, NetBSD and NFS |