+ :address => "10.0.48.50",
+ :bond => {
+ :slaves => %w[enp1s0f0 enp1s0f1]
+ }
+ }
+ }
+ },
+ :postgresql => {
+ :settings => {
+ :defaults => {
+ :shared_buffers => "64GB",
+ :work_mem => "64MB",
+ :maintenance_work_mem => "1GB",
+ :effective_cache_size => "180GB",
+ :effective_io_concurrency => "256",
+ :random_page_cost => "1.1"
+ }
+ }
+ },
+ :sysctl => {
+ :postgres => {
+ :comment => "Increase shared memory for postgres",
+ :parameters => {
+ "kernel.shmmax" => 66 * 1024 * 1024 * 1024,
+ "kernel.shmall" => 66 * 1024 * 1024 * 1024 / 4096
+ }
+ }
+ },
+ :sysfs => {
+ :md_tune => {
+ :comment => "Enable request merging for NVMe devices",
+ :parameters => {
+ "block/nvme0n1/queue/nomerges" => "1",
+ "block/nvme1n1/queue/nomerges" => "1",
+ "block/nvme2n1/queue/nomerges" => "1",
+ "block/nvme3n1/queue/nomerges" => "1",
+ "block/nvme4n1/queue/nomerges" => "1",
+ "block/nvme5n1/queue/nomerges" => "1",
+ "block/nvme6n1/queue/nomerges" => "1",
+ "block/nvme7n1/queue/nomerges" => "1"