| Search Type | Additional Storage | Index Size | Notes |
|---|---|---|---|
| Exact Match | None | ~2–5% of data | B-tree indexes |
| Pattern Match | None | ~10–20% | GIN trigram indexes |
| Full-Text | ~20–50% | ~10–30% | tsvector + GIN index |
| Vector Search | ~50–200% | ~20–100% | Depends on dimensions |
| Fuzzy Search | None | ~10–20% | Uses trigram indexes |
Created
August 25, 2025 15:48
-
-
Save sany2k8/46c29f3257275a99dca837ad06fd0139 to your computer and use it in GitHub Desktop.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment