diff options
| author | Kevin Fenzi <kevin@scrye.com> | 2016-04-04 21:02:54 +0000 |
|---|---|---|
| committer | Kevin Fenzi <kevin@scrye.com> | 2016-04-04 21:02:54 +0000 |
| commit | 0215b152b2527359b0d1d1d16b684867e7d9e6a5 (patch) | |
| tree | 875534862f6ca640c333959a21eb6c1cf266a5d5 | |
| parent | 856abe494eb537f056a8b43d951505c22aa2456e (diff) | |
| download | ansible-0215b152b2527359b0d1d1d16b684867e7d9e6a5.tar.gz ansible-0215b152b2527359b0d1d1d16b684867e7d9e6a5.tar.xz ansible-0215b152b2527359b0d1d1d16b684867e7d9e6a5.zip | |
Set effective cache size for all these postgresql role using machines that aren't dedicated db servers
4 files changed, 6 insertions, 2 deletions
diff --git a/inventory/host_vars/pagure-stg01.fedoraproject.org b/inventory/host_vars/pagure-stg01.fedoraproject.org index bdc648e50..c7fca4ee0 100644 --- a/inventory/host_vars/pagure-stg01.fedoraproject.org +++ b/inventory/host_vars/pagure-stg01.fedoraproject.org @@ -18,4 +18,5 @@ datacenter: osuosl # PostgreSQL configuration # -shared_buffers: "32MB" +shared_buffers: "2GB" +effective_cache_size: "6GB" diff --git a/inventory/host_vars/pagure01.fedoraproject.org b/inventory/host_vars/pagure01.fedoraproject.org index 7ec1028c4..9c85e9c13 100644 --- a/inventory/host_vars/pagure01.fedoraproject.org +++ b/inventory/host_vars/pagure01.fedoraproject.org @@ -19,3 +19,4 @@ datacenter: osuosl # shared_buffers: "32MB" +effective_cache_size: "512MB" diff --git a/inventory/host_vars/regcfp.fedorainfracloud.org b/inventory/host_vars/regcfp.fedorainfracloud.org index 540539367..cf8c74bf0 100644 --- a/inventory/host_vars/regcfp.fedorainfracloud.org +++ b/inventory/host_vars/regcfp.fedorainfracloud.org @@ -19,4 +19,4 @@ cloud_networks: custom_rules: [ '-A INPUT -p tcp -m tcp --dport 5432 -j ACCEPT' ] shared_buffers: "1GB" - +effective_cache_size: "2GB" diff --git a/inventory/host_vars/testdays.fedorainfracloud.org b/inventory/host_vars/testdays.fedorainfracloud.org index 017650c13..88cf72146 100644 --- a/inventory/host_vars/testdays.fedorainfracloud.org +++ b/inventory/host_vars/testdays.fedorainfracloud.org @@ -24,6 +24,8 @@ freezes: false ############################################################ shared_buffers: "32MB" +effective_cache_size: "256MB" + host_backup_targets: ['/backups'] dbs_to_backup: - testdays |