diff options
| author | Yorick Peterse <yorickpeterse@gmail.com> | 2017-08-09 15:49:30 +0200 |
|---|---|---|
| committer | Yorick Peterse <yorickpeterse@gmail.com> | 2017-08-11 16:43:30 +0200 |
| commit | a5c8a52782ae6e948adbbba77c0ec702ffe28ae1 (patch) | |
| tree | 1a46e36340cb87ed2768f47d049dd2d705acd947 /changelogs | |
| parent | e80a893ff0ea8466099f6478183631af55933db2 (diff) | |
| download | gitlab-ce-a5c8a52782ae6e948adbbba77c0ec702ffe28ae1.tar.gz | |
Better caching and indexing of broadcast messages
Caching of BroadcastMessage instances has been changed so a cache stays
valid as long as the default cache expiration time permits, instead of
the cache being expired after 1 minute. When modifying broadcast
messages the cache is flushed automatically.
To remove the need for performing sequence scans on the
"broadcast_messages" table we also add an index on (starts_at, ends_at,
id), permitting PostgreSQL to use an index scan to get all necessary
data.
Finally this commit adds a few NOT NULL constraints to the table to
match the Rails validations.
Fixes gitlab-org/gitlab-ce#31706
Diffstat (limited to 'changelogs')
| -rw-r--r-- | changelogs/unreleased/broadcast-messages-cache.yml | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/changelogs/unreleased/broadcast-messages-cache.yml b/changelogs/unreleased/broadcast-messages-cache.yml new file mode 100644 index 00000000000..a3c9e1ff465 --- /dev/null +++ b/changelogs/unreleased/broadcast-messages-cache.yml @@ -0,0 +1,4 @@ +--- +title: Better caching and indexing of broadcast messages +merge_request: +author: |