From b29e519bc13e0f213e29a33450d16cb54167173d Mon Sep 17 00:00:00 2001 From: Paul Norman Date: Thu, 7 Nov 2024 13:15:19 -0800 Subject: [PATCH] Increase max_connections for worst-case --- cookbooks/vectortile/attributes/default.rb | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/cookbooks/vectortile/attributes/default.rb b/cookbooks/vectortile/attributes/default.rb index 0df4249e7..b5e0933a6 100644 --- a/cookbooks/vectortile/attributes/default.rb +++ b/cookbooks/vectortile/attributes/default.rb @@ -10,6 +10,7 @@ default[:vectortile][:replication][:threads] = node.cpu_cores default[:postgresql][:versions] |= [node[:vectortile][:database][:cluster].split("/").first] default[:postgresql][:monitor_database] = "tiles" -default[:postgresql][:settings][:defaults][:max_connections] = (node.cpu_cores * 4 + 20).to_s +# As an absolute worst case, the server might have the serving, update, and a manual generation process going on. +default[:postgresql][:settings][:defaults][:max_connections] = (node.cpu_cores * 6 + 20).to_s default[:accounts][:users][:tileupdate][:status] = :role default[:accounts][:users][:tilekiln][:status] = :role -- 2.39.5