A LinkedIn post from ClickHouse highlights performance results for pg_re2, an extension that brings the RE2 regular expression engine to PostgreSQL. The post suggests that pg_re2 delivers between 1.8x and 8.6x faster regex performance than native PostgreSQL functions across search, replace, extract, and split operations.
According to the post, extraction functions see the largest gains, in the range of 7.2x to 8.6x, and the extension supports GIN and btree indexes, including a new gin_re2_ops opclass for trigram indexing across punctuation. The post also indicates that queries previously falling back to full table scans may now benefit from index usage, potentially improving query efficiency for regex-heavy workloads.
The post further notes that pg_re2 uses the same function names and behavior as ClickHouse’s regex engine to align results with the pg_clickhouse integration. It is installed as a standard PostgreSQL extension via CREATE EXTENSION re2, which may lower adoption friction for developers and data teams.
For investors, the post suggests ClickHouse is emphasizing interoperability and performance in mixed database environments where PostgreSQL remains entrenched. This positioning could enhance ClickHouse’s appeal in analytics and data-engineering use cases, potentially supporting user growth and reinforcing its competitive stance against other high-performance database vendors.