Skip site navigation (1) Skip section navigation (2)

Re: Pathological regexp match

From: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: Michael Glaesemann <michael(dot)glaesemann(at)myyearbook(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Pathological regexp match
Date: 2010-02-08 17:07:04
Message-ID: 93227435-49FA-4915-8FA6-6976062E65DD@kineticode.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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

Best,

David


In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2010-02-08 17:29:39
Subject: Order of operations in lazy_vacuum_rel
Previous:From: Robert HaasDate: 2010-02-08 16:54:49
Subject: Re: damage control mode

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group