Re: POSIX regex performance bug in 7.3 Vs. 7.2

From: Neil Conway <neilc(at)samurai(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Jon Jensen <jon(at)endpoint(dot)com>, wade <wade(at)wavefire(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: POSIX regex performance bug in 7.3 Vs. 7.2
Date: 2003-02-04 22:50:30
Message-ID: 1044399030.6534.1167.camel@tokyo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, 2003-02-04 at 17:26, Tom Lane wrote:
> Proof of concept:
> [...]

Very cool work, Tom.

> In the first case there are only four distinct patterns used, so we're
> running with cached precompiled regexes. In the other cases a new regex
> compilation must occur at each row.

Speaking of which, is there (or should there be) some mechanism for
increasing the size of the compiled pattern cache? Perhaps a GUC var?

Cheers,

Neil
--
Neil Conway <neilc(at)samurai(dot)com> || PGP Key ID: DB3C29FC

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Curt Sampson 2003-02-04 22:52:37 Re: PGP signing releases
Previous Message Tom Lane 2003-02-04 22:46:49 Re: POSIX regex performance bug in 7.3 Vs. 7.2