Re: regex cache

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: regex cache
Date: 2008-06-18 14:33:22
Message-ID: 200806180733.23044.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom,

> Having said that, I'm not sure it'd help your problem. If your query is
> using more than 32 regexes concurrently, it likely is using $BIGNUM
> regexes concurrently. How do we fix that?

Hmmm. I think there's a lot of ground between 32 and $BIGNUM. For example,
where I'm hitting a wall is 300 regexes. Some quick testing on my opteron
text machine right now shows that the execution time difference between 20rx
and 50rx is around 20x.

--
Josh Berkus
PostgreSQL @ Sun
San Francisco

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-06-18 14:36:04 Re: pg_dump fails to include sequences, leads to restore fail in any version
Previous Message Alvaro Herrera 2008-06-18 14:32:12 Re: [HACKERS] Hint Bits and Write I/O