Skip to content
Snippets Groups Projects
Select Git revision
  • master default protected
  • 12-9-stable
  • 12-7-stable
  • 12-6-stable
  • 12-8-stable
  • github/fork/Kloppi313/patch-1
  • 12-5-stable
  • 12-4-stable
  • github/fork/ramalokesh8477/master
  • 12-1-stable
  • 12-2-stable
  • 12-0-stable
  • 12-3-stable
  • 42-42-stable
  • github/fork/hussamgit398/patch-2
  • 12-3-auto-deploy-20190911
  • 12-3-auto-deploy-20190916
  • 12-3-auto-deploy-20190908
  • 12-3-auto-deploy-20190901
  • 12-3-auto-deploy-20190901-32664
  • v12.10.0.pre
  • v12.9.0
  • v12.9.0-rc42
  • v12.8.7
  • v12.8.6
  • v12.8.5
  • v12.8.4
  • v12.8.3
  • v12.6.8
  • v12.7.7
  • v12.8.2
  • v12.8.1
  • v12.9.0.pre
  • v12.8.0
  • v12.8.0-rc42
  • v12.5.10
  • v12.7.6
  • v12.6.7
  • v12.7.5
  • v12.5.9
40 results

broadcast_message.rb

  • Yorick Peterse's avatar
    a5c8a527
    Better caching and indexing of broadcast messages · a5c8a527
    Yorick Peterse authored
    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
    Verified
    a5c8a527
    History
    Better caching and indexing of broadcast messages
    Yorick Peterse authored
    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