:postgresql => {
:settings => {
:defaults => {
- :shared_buffers => "10GB",
:work_mem => "300MB",
:maintenance_work_mem => "10GB",
:random_page_cost => "1.5",
:checkpoint_segments => "32",
:checkpoint_timeout => "10min",
:checkpoint_completion_target => "0.9",
+ :shared_buffers => "2GB",
:autovacuum_max_workers => "1"
}
}
:postgresql => {
:settings => {
:defaults => {
- :shared_buffers => "10GB",
:work_mem => "160MB",
:maintenance_work_mem => "10GB",
:random_page_cost => "1.5",
:settings => {
:defaults => {
:listen_addresses => "10.0.0.20",
- :shared_buffers => "10GB",
:work_mem => "160MB",
:maintenance_work_mem => "10GB",
:random_page_cost => "1.5",