:sources => ["postgresql"]
},
:db => {
- :cluster => "9.1/main"
+ :cluster => "9.5/main"
},
:networking => {
:interfaces => {
:work_mem => "64MB",
:maintenance_work_mem => "1GB",
:effective_cache_size => "180GB",
- :effective_io_concurrency => "256"
+ :effective_io_concurrency => "256",
+ :random_page_cost => "1.1"
}
- },
- :versions => ["9.1"]
+ }
},
:sysctl => {
:postgres => {
"block/nvme2n1/queue/nomerges" => "1",
"block/nvme3n1/queue/nomerges" => "1",
"block/nvme4n1/queue/nomerges" => "1",
- "block/nvme5n1/queue/nomerges" => "1"
+ "block/nvme5n1/queue/nomerges" => "1",
+ "block/nvme6n1/queue/nomerges" => "1",
+ "block/nvme7n1/queue/nomerges" => "1"
}
}
}
run_list(
"role[ic]",
- "role[db-slave]"
+ "role[db-master]",
+ "role[db-backup]"
)