Gather even more postgres statistics

[chef.git] / roles / odin.rb

diff --git a/roles/odin.rb b/roles/odin.rb
index e31bc6923f408babd19303045e1a298ed3d69704..238e403ae90f54ffd6174a20772a5a7b236b2f25 100644 (file)
--- a/roles/odin.rb
+++ b/roles/odin.rb
@@ -26,9 +26,41 @@ default_attributes(
         :address => "2001:978:2:2C::172:F"
       }
     }
         :address => "2001:978:2:2C::172:F"
       }
     }

+  },
+  :postgresql => {
+    :settings => {
+      :defaults => {
+        :shared_buffers => "8GB",
+        :maintenance_work_mem => "7144MB",
+        :effective_cache_size => "16GB"
+      }
+    }
+  },
+  :sysctl => {
+    :postgres => {
+      :comment => "Increase shared memory for postgres",
+      :parameters => {
+        "kernel.shmmax" => 9 * 1024 * 1024 * 1024,
+        "kernel.shmall" => 9 * 1024 * 1024 * 1024 / 4096
+      }
+    }
+  },
+  :tile => {
+    :database => {
+      :cluster => "12/main",
+      :postgis => "3"
+    },
+    :styles => {
+      :default => {
+        :tile_directories => [
+          { :name => "/store/tiles/default", :min_zoom => 0, :max_zoom => 19 }
+        ]
+      }
+    }

   }
 )
 
 run_list(
   }
 )
 
 run_list(

-  "role[equinix]"
+  "role[equinix]",
+  "role[tile]"

 )
 )