24 ms·
We've been considering which minimum version requirement of PostgreSQL at GitLab here: https://gitlab.com/gitlab-org/gitlab/issues/31454 https://gitlab.com/gitl
by craigg 7y ago
We've been considering which minimum version requirement of PostgreSQL at GitLab here: https://gitlab.com/gitlab-org/gitlab/issues/31454 https://gitlab.com/gitlab-org/gitlab/issues/31454. We will add PostgreSQL 12 for consideration as well.
The partitioning improvements will help with our events tables (https://gitlab.com/gitlab-org/gitlab/issues/24538 https://gitlab.com/gitlab-org/gitlab/issues/24538) as Sid notes above. Also the notable improvements in query performance, especially over large data sets will help with the other large tables we need to address. Most notably:
merge_request_diff_commits https://gitlab.com/gitlab-org/gitlab/issues/31454 https://gitlab.com/gitlab-org/gitlab/issues/31454
and ci_builds https://gitlab.com/gitlab-org/gitlab/issues/30441 https://gitlab.com/gitlab-org/gitlab/issues/30441