TechHacker Newsabout 3 hours ago
Pg_re2 brings fast RE2 regex to Postgres
1 min read
ClickHouse released pg_re2, a Postgres extension for RE2-powered regular expressions. RE2 outperforms Postgres native regex by 1.8x to 8.6x in benchmarks. The extension adds a @~ operator and btree/GIN index support. Pg_clickhouse v0.3.0 adds pg_re2 function pushdown to resolve syntax mismatches between ClickHouse and Postgres regex engines.
Level
Hype check
Tap to vote and see what everyone thinks.
