NEW THINGS FOR REGULAR EXPRESSIONS IN POSTGRESQL: PG_TRE AND PG_RE2

Summary from the TLDR Data newsletter

PostgreSQL regex search can vary wildly by index and extension. In a 1.6M-row, 33 GB plan table, pg_trgm cut a simple LIKE scan from about 40 seconds to 1.6 seconds, pg_tre added fuzzy matching but had painful index build time, and pg_re2 delivered faster regex execution with fewer language features.