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

Yorick Peterse 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 !1500 (comment 33169528).