Skip to content
Snippets Groups Projects
  1. Aug 27, 2024
  2. Aug 21, 2024
  3. Aug 20, 2024
  4. Aug 07, 2024
  5. Aug 20, 2024
  6. Aug 18, 2024
    • Stan Hu's avatar
      Raise default PostgreSQL shared buffers minimum to 256 MB · b981f9b6
      Stan Hu authored
      Previously the Docker container set the PostgreSQL shared buffers to a
      minimum of 1 MB to avoid using the default of 25% of the node's
      memory. While that meager value worked previously, this value is not
      only overly conservative but it is now insufficient for background
      migrations that have a large number of partitioned tables.
      
      From
      https://gitlab.com/gitlab-org/omnibus-gitlab/-/issues/8682#note_2058612975
      we see that the 2 years of `audit_events` needs about 20 MB just to
      query the table metadata. The 1 MB value failed with `no unpinned
      buffers available` because PostgreSQL needs more shared buffers for
      query planning.
      
      Raise the default to 256 MB to provide enough headroom for future
      tables and to ensure PostgreSQL effectively caches data. Update the
      documentation in the template accordingly.
      
      Relates to https://gitlab.com/gitlab-org/omnibus-gitlab/-/issues/8682
      
      Changelog: fixed
      b981f9b6
  7. Aug 19, 2024
  8. Aug 16, 2024
  9. Aug 15, 2024
  10. Aug 12, 2024
  11. Aug 14, 2024
  12. Aug 13, 2024
  13. Aug 01, 2024
  14. Aug 13, 2024
  15. Aug 01, 2024
  16. Aug 11, 2024
  17. Aug 09, 2024
Loading