Re: regex cache

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: regex cache
Дата
Msg-id 200806180733.23044.josh@agliodbs.com
обсуждение исходный текст
Ответ на Re: regex cache  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: regex cache  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Reducing overhead for repeat de-TOASTing
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Better error reporting for tsearch config file problems