Set reasonable PostgreSQL GUCs for tile servers

[chef.git] / roles / tile.rb

diff --git a/roles/tile.rb b/roles/tile.rb
index 6bb3dc9023f340283e70f1fc77e14d50a3562743..88a971145373651c786a6eaba5f75ae0e833e064 100644 (file)
--- a/roles/tile.rb
+++ b/roles/tile.rb
@@ -34,14 +34,16 @@ default_attributes(
     :settings => {
       :defaults => {
         :max_connections => "250",
-        :temp_buffers => "32MB",
+        :shared_buffers => "16GB",
         :work_mem => "128MB",
+        :maintenance_work_mem => "8GB",
         :max_parallel_workers_per_gather => "0",
         :wal_level => "minimal",
         :wal_buffers => "1024kB",
         :wal_writer_delay => "500ms",
+        :checkpoint_timeout => "60min"
         :commit_delay => "10000",
-        :max_wal_size => "2880MB",
+        :max_wal_size => "10GB",
         :max_wal_senders => "0",
         :jit => "off",
         :track_activity_query_size => "16384",