diff options
Diffstat (limited to 'doc/development/sql.md')
| -rw-r--r-- | doc/development/sql.md | 4 |
1 files changed, 1 insertions, 3 deletions
diff --git a/doc/development/sql.md b/doc/development/sql.md index 2584dcfb4ca..8a8204ffe87 100644 --- a/doc/development/sql.md +++ b/doc/development/sql.md @@ -74,7 +74,7 @@ USING GIN(column_name gin_trgm_ops); ``` The key here is the `GIN(column_name gin_trgm_ops)` part. This creates a [GIN -index][gin-index] with the operator class set to `gin_trgm_ops`. These indexes +index](https://www.postgresql.org/docs/current/gin.html) with the operator class set to `gin_trgm_ops`. These indexes _can_ be used by `ILIKE` / `LIKE` and can lead to greatly improved performance. One downside of these indexes is that they can easily get quite large (depending on the amount of data indexed). @@ -247,8 +247,6 @@ WHERE EXISTS ( ) ``` -[gin-index]: http://www.postgresql.org/docs/current/static/gin.html - ## `.find_or_create_by` is not atomic The inherent pattern with methods like `.find_or_create_by` and |