# Introducing pg\_re2, fast, RE2-powered regular expressions in Postgres

DevFeed: [Introducing pg\_re2, fast, RE2-powered regular expressions in Postgres](<https://devfeed.tech/articles/introducing-pg-re2-fast-re2-powered-regular-expressions-in-postgres-5337.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/introducing-pg_re2-regex-in-postgres>)

Author: David Wheeler; Philip Dubé

Published: 2026-07-08T18:12:04Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Regular expression](<https://devfeed.tech/topics/regular-expression.md>), [Extension](<https://devfeed.tech/topics/extension.md>), [Benchmark](<https://devfeed.tech/topics/benchmark.md>), [Finite-state machine](<https://devfeed.tech/topics/finite-state-machine.md>), [Automaton](<https://devfeed.tech/topics/automaton.md>), [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>)

Tags: [algorithms](<https://devfeed.tech/tags/algorithms.md>), [article](<https://devfeed.tech/tags/article.md>), [aws](<https://devfeed.tech/tags/aws.md>), [benchmark](<https://devfeed.tech/tags/benchmark.md>), [benchmarks](<https://devfeed.tech/tags/benchmarks.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [development](<https://devfeed.tech/tags/development.md>), [engineering](<https://devfeed.tech/tags/engineering.md>), [extension](<https://devfeed.tech/tags/extension.md>), [open](<https://devfeed.tech/tags/open.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [performance](<https://devfeed.tech/tags/performance.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [sql](<https://devfeed.tech/tags/sql.md>)

## AI overview

This article introduces pg_re2, a PostgreSQL extension that adds fast RE2-powered regular expression functions. It explains the performance and compatibility rationale, compares RE2 with PostgreSQL's native engine, and reports benchmark results showing RE2 outperforming the native functions in the tested cases.

## Source excerpt

Introducing pg_re2, a Postgres extension that brings ClickHouse's fast RE2-powered regular expressions to Postgres, with benchmarks and pg_clickhouse pushdown integration.