Skip to content

Instantly share code, notes, and snippets.

@slabad

slabad/gin_index_example.sql

Created September 21, 2021 12:23
Show Gist options
  • Save slabad/3ed0b9aa168c918a09da78405f071a53 to your computer and use it in GitHub Desktop.
Save slabad/3ed0b9aa168c918a09da78405f071a53 to your computer and use it in GitHub Desktop.
Download ZIP
gin index example #postgres #psql #index
Raw
gin_index_example.sql
CREATE INDEX index_notifications_gin_subscriber ON notifications USING gin ((params ->> 'subscriber') gin_trgm_ops) WHERE params -> 'subscriber':: text IS NOT NULL;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment