posts tagged with indexing.
go to all tags.
-
pg_tre: approximate regex as a real Postgres index AM
A native USING tre index access method with three-tier filtering, WAL coverage, and Levenshtein-distance recheck. Sub-millisecond on tens of thousands of rows.