New things for regular expressions in PostgreSQL (pg_tre and pg_re2)
Summary
The article surveys new PostgreSQL regex capabilities via pg_tre and pg_re2 extensions, comparing them to built-in pg_trgm. It discusses installation, indexing, and performance trade-offs, including heavy initial indexing costs but strong query speed with trigram-like patterns and various pattern capabilities. It also shows practical examples and notes current limitations.