]> git.openstreetmap.org Git - chef.git/blobdiff - roles/tile.rb
Switch nidhogg to use postgres 16
[chef.git] / roles / tile.rb
index 6bb3dc9023f340283e70f1fc77e14d50a3562743..ac642a758e6c0d88419a7ebda46df652baf8f4bc 100644 (file)
@@ -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",