Introducing pg_re2, fast, RE2-powered regular expressions in Postgres
Summary
The article announces pg_re2, a Postgres extension powered by Google's RE2 to deliver fast regular expressions in PostgreSQL. It explains installation, usage with examples, and presents benchmarks showing significant speedups over native Postgres regex. It also discusses indexing, cross-database pushdown with pg_clickhouse, and differences between Postgres POSIX regex and RE2 syntax, recommending pg_re2 for faster regex processing and unified analytics with ClickHouse.