projects
/
chef.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
27e33fa
)
Set autovacuum scale factors for tile servers
author
Paul Norman
<penorman@mac.com>
Tue, 20 Feb 2018 14:35:37 +0000
(06:35 -0800)
committer
Tom Hughes
<tom@compton.nu>
Tue, 20 Feb 2018 16:09:46 +0000
(16:09 +0000)
Reducing these factors helps make sure autovacuum runs often
enough and keeps bloat down.
Closes #152
roles/tile.rb
patch
|
blob
|
history
diff --git
a/roles/tile.rb
b/roles/tile.rb
index 6c7da5a019a4bf8626317213aaaa6fb56a45b9a9..b0f7c930e6b1ca5892dff1d5b04dd06db63cc45b 100644
(file)
--- a/
roles/tile.rb
+++ b/
roles/tile.rb
@@
-43,7
+43,9
@@
default_attributes(
:checkpoint_segments => "60",
:max_wal_size => "2880MB",
:random_page_cost => "1.1",
- :track_activity_query_size => "16384"
+ :track_activity_query_size => "16384",
+ :autovacuum_vacuum_scale_factor => "0.05",
+ :autovacuum_analyze_scale_factor => "0.02"
}
}
},