diff options
author | Yorick Peterse <yorickpeterse@gmail.com> | 2017-10-02 10:14:23 +0200 |
---|---|---|
committer | Yorick Peterse <yorickpeterse@gmail.com> | 2017-10-02 15:31:59 +0200 |
commit | c16b99a49c58161971d1a86613930be439385f02 (patch) | |
tree | efe023f415f4df81b27a8c895b848a71a8c21bff /changelogs | |
parent | 147c46cca195f13ef10ec8fc2db160a833121914 (diff) | |
download | gitlab-ce-c16b99a49c58161971d1a86613930be439385f02.tar.gz |
Use a UNION ALL for getting merge request notesmerge-request-notes-performance
In this particular case the use of UNION ALL leads to a better query
plan compared to using 1 big query that uses an OR statement to combine
different data sources.
See https://gitlab.com/gitlab-org/gitlab-ce/issues/38508 for more
information.
Diffstat (limited to 'changelogs')
-rw-r--r-- | changelogs/unreleased/merge-request-notes-performance.yml | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/changelogs/unreleased/merge-request-notes-performance.yml b/changelogs/unreleased/merge-request-notes-performance.yml new file mode 100644 index 00000000000..6cf7a5047df --- /dev/null +++ b/changelogs/unreleased/merge-request-notes-performance.yml @@ -0,0 +1,5 @@ +--- +title: Use a UNION ALL for getting merge request notes +merge_request: +author: +type: other |