Re: Pathological regexp match - Mailing list pgsql-hackers

From Joachim Wieland
Subject Re: Pathological regexp match
Date
Msg-id dc7b844e1002090733s2bee3891x809a4f4541e054c5@mail.gmail.com
Whole thread Raw
In response to Re: Pathological regexp match  ("David E. Wheeler" <david@kineticode.com>)
List pgsql-hackers
On Mon, Feb 8, 2010 at 6:07 PM, David E. Wheeler <david@kineticode.com> wrote:
> On Feb 8, 2010, at 5:15 AM, Magnus Hagander wrote:
>
>> The text is about 180Kb. PostgreSQL takes ~40 seconds without the
>> patch, ~36 seconds with it, to extract the match from it. Perl takes
>> 0.016 seconds.
>
> Obviously we need to support Perl regular expressions in core. Not PCRE, but Perl. ;-P

FWIW, PCRE is BSD licensed, so we could actually include it... Would
be interesting to see how it performs on the pattern at hand.


Joachim


pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: About psycopg2 (by its author)
Next
From: Pavel Stehule
Date:
Subject: bugfix - VIP: variadic function ignore strict flag