Re: POSIX regex performance bug in 7.3 Vs. 7.2 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: POSIX regex performance bug in 7.3 Vs. 7.2
Date
Msg-id 22580.1044425574@sss.pgh.pa.us
Whole thread Raw
In response to Re: POSIX regex performance bug in 7.3 Vs. 7.2  (Hannu Krosing <hannu@tm.ee>)
Responses Re: POSIX regex performance bug in 7.3 Vs. 7.2  (Hannu Krosing <hannu@tm.ee>)
List pgsql-hackers
Hannu Krosing <hannu@tm.ee> writes:
> Another idea is to make special regex type and store the regexes
> pre-parsed (i.e. in some fast-load form) ?

Seems unlikely that going out to disk could beat just recompiling the
regexp.  They're not *that* slow to compile ... at least not when we
avoid the performance problem that we introduced into the older regexp
code.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: POSIX regex performance bug in 7.3 Vs. 7.2
Next
From: Curt Sampson
Date:
Subject: Re: PGP signing releases