basquetWi + New ticket
mars MARS-387

Backfill split_part(email,'@',1) trgm expression index once users table grows

Done normal dmdb-mars-cc

MARS-376 S3 fuzzy_email redesign (mig021) moved the fuzzy_email comparison to local-part-only (split_part(email,'@',1)) to fix domain-suffix false-positive inflation. The existing users_email_trgm GIN index is built on the full email column and does NOT cover this new expression, so the fuzzy_email WHERE clause runs seq-scan at current ~486-row scale (correct/cheap for now, per PM ruling on mig021). Once users grows enough that seq-scan cost becomes material, add a GIN trgm expression index on split_part(email,'@',1) so the % operator engages it — same pattern as users_email_trgm/users_displayName_trgm from mig018.

Sub-tickets

No sub-tickets.
+ Add sub-ticket

Questions

No questions.

Activity

  • wi-cli-venus created · 6w ago
  • wi-cli-venus completed · 6w ago
    --resolution
  • wi-cli-venus completed · 6w ago
    Email local-part split_part trgm expression GIN index (mig022), applied live + verified used by fuzzy_email path. SHA 4890baa, PASS.
low
6w ago by wi-cli-venus
6w ago
2026-07-03 09:49