Update various PostgreSQL default settings (!1675) · Merge requests · GitLab.org / omnibus-gitlab · GitLab

Do not update/delete: Banner broadcast message test data

Do not update/delete: Notification broadcast message test data

yorickpeterse-staging requested to merge update-postgresql-defaults into master Jun 22, 2017

This changes:

work_mem from 8MB to 16MB
statement_timeout from 0 (= no timeout) to 60 seconds
random_page_cost from 4.0 to 2.0
max_locks_per_transaction from 64 to 128

These settings are based on what we use for GitLab.com.

Originally requested in https://gitlab.com/gitlab-org/omnibus-gitlab/merge_requests/1500#note_33169528.