summaryrefslogtreecommitdiff
path: root/changelogs
diff options
context:
space:
mode:
authorYorick Peterse <yorickpeterse@gmail.com>2017-10-02 10:14:23 +0200
committerYorick Peterse <yorickpeterse@gmail.com>2017-10-02 15:31:59 +0200
commitc16b99a49c58161971d1a86613930be439385f02 (patch)
treeefe023f415f4df81b27a8c895b848a71a8c21bff /changelogs
parent147c46cca195f13ef10ec8fc2db160a833121914 (diff)
downloadgitlab-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.yml5
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