database.pp

# Connection limit
  postgresql::server::config_entry { 'max_connections':
    value => '500',
  }

  # Memory Settings
  postgresql::server::config_entry { 'shared_buffers':
    value => '2GB',
  }

  # effective_cache_size Memory Settings
  postgresql::server::config_entry { 'effective_cache_size':
    value => '6GB',
  }

  # maintenance_work_mem Memory Settings
  postgresql::server::config_entry { 'maintenance_work_mem':
    value => '512MB',
  }

  # wal_buffers Memory Settings
  postgresql::server::config_entry { 'wal_buffers':
    value => '16MB',
  }

  # default_statistics_target Memory Settings
  postgresql::server::config_entry { 'default_statistics_target':
    value => '100',
  }

  # random_page_cost Memory Settings
  postgresql::server::config_entry { 'random_page_cost':
    value => '1.1',
  }

  # effective_io_concurrency Settings
  postgresql::server::config_entry { 'effective_io_concurrency':
    value => '300',
  }

  # work_mem Settings
  postgresql::server::config_entry { 'work_mem':
    value => '2097kB',
  }

  # min_wal_size Settings
  postgresql::server::config_entry { 'min_wal_size':
    value => '1GB',
  }

  # max_wal_size Settings
  postgresql::server::config_entry { 'max_wal_size':
    value => '2GB',
  }

  # max_worker_processes Settings
  postgresql::server::config_entry { 'max_worker_processes':
    value => '4',
  }

  # max_parallel_workers_per_gather Settings
  postgresql::server::config_entry { 'max_parallel_workers_per_gather':
    value => '2',
  }

  # checkpoint_completion_target Settings
  postgresql::server::config_entry { 'checkpoint_completion_target':
    value => '0.7',
  }

  # Replication
  postgresql::server::config_entry { 'archive_mode':
    value => 'on',
  }

  postgresql::server::config_entry { 'archive_command':
    value => 'test ! -f /var/lib/pgsql/archive/%f && cp %p /var/lib/pgsql/archive/%f',
  }

  postgresql::server::config_entry { 'archive_timeout':
    value => '600',
  }

  postgresql::server::config_entry { 'wal_level':
    value => 'hot_standby',
  }

  postgresql::server::config_entry { 'max_wal_senders':
    value => '5',
  }

  postgresql::server::config_entry { 'hot_standby':
    value => 'on',
  }

  postgresql::server::config_entry { 'log_checkpoints':
    value =>  'on',
  }

  postgresql::server::config_entry { 'log_connections':
    value =>  'on',
  }

  postgresql::server::config_entry { 'log_disconnections':
    value =>  'on',
  }

  postgresql::server::config_entry { 'log_lock_waits':
    value =>  'on',
  }

  postgresql::server::config_entry { 'log_temp_files':
    value =>  '0',
  }
  # Finish Logging Settings