X-Git-Url: https://git.openstreetmap.org/chef.git/blobdiff_plain/dab01b1b3b0e66ab6c2ccf0106e07d66ce8048a7..dc7216b15b33567990e864c855d928ac9e73ad07:/cookbooks/timescaledb/recipes/default.rb diff --git a/cookbooks/timescaledb/recipes/default.rb b/cookbooks/timescaledb/recipes/default.rb index 4ae90c361..776cab655 100644 --- a/cookbooks/timescaledb/recipes/default.rb +++ b/cookbooks/timescaledb/recipes/default.rb @@ -30,6 +30,7 @@ memory_gb = (node[:memory][:total].to_f / 1024 / 1024).ceil node.default_unless[:postgresql][:versions] = [] node.default[:postgresql][:versions] |= [database_version] +node.default[:postgresql][:monitor_tables] = false node.default[:postgresql][:settings][database_version][:max_connections] = 500 node.default[:postgresql][:settings][database_version][:shared_buffers] = "#{memory_gb / 4}GB" node.default[:postgresql][:settings][database_version][:work_mem] = "#{memory_gb * 128 / 50 / node[:cpu][:total]}MB"