Cheat Sheet logoCheat Sheet Today
PostgreSQL Advanced Cheat Sheet/Create trigram index

Accelerate ILIKE and fuzzy matches on text.

Back to sheetBrowse commands
Sign in to save
Section: Extensions and Specialized Utilities

Create trigram index

sql
sql
CREATE INDEX idx_users_email_trgm ON public.users USING GIN (email gin_trgm_ops);
Explanation

See summary for usage details.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing Extensions and Specialized Utilities
Enable pg_trgm
Install trigram support for similarity search and GIN/GiST indexes.
OpenIn sheetsqlsame section
Enable citext
Install case-insensitive text type support.
OpenIn sheetsqlsame section
Use CITEXT
Make a column case-insensitive with the `citext` type.
OpenIn sheetsqlsame section
Enable pgstattuple
Install size and tuple-stat inspection helpers.
OpenIn sheetsqlsame section
Check table bloat stats
Estimate dead tuples and free space in a relation.
OpenIn sheetsqlsame section
Enable uuid-ossp
Install UUID generation helpers.
OpenIn sheetsqlsame section