diff options
author | GitLab Bot <gitlab-bot@gitlab.com> | 2019-09-27 15:06:07 +0300 |
---|---|---|
committer | GitLab Bot <gitlab-bot@gitlab.com> | 2019-09-27 15:06:07 +0300 |
commit | 45482d5a2704da7fabe4ccf07f85d9be6e0a791a (patch) | |
tree | 838353cda1b2a06a08799e852f3a7f338c715b44 /doc/development/sql.md | |
parent | 20450649ca3132e55aea60436fa6117ca6c1ae5f (diff) |
Add latest changes from gitlab-org/gitlab@master
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 |