I recently setup a GIN index on a large database, and it's performance is
spectacular. However, I noticed by default it doesn't allow searching by
partial matches.
The docs (http://www.postgresql.org/docs/9.5/static/gin-implementation.html)
claim partial matching is supported but don't actually explain how to
enable it. Are there any examples of creating a GIN index that uses partial
matching? I'm not finding anything through Google.