sql: optimize trigram generator #86610
Labels
C-enhancement
Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)
O-qa
T-sql-queries
SQL Queries Team
Projects
The latency difference between our
show_trgm
builtin and Postgres's suggestions that there may be opportunities to optimize our trigram generation code. On my machine, the queryselect show_trgm('hello world') from generate_series(1, 10000);
takes ~73ms in CRDB and ~14ms in PG.Jira issue: CRDB-18836
The text was updated successfully, but these errors were encountered: