:postgresql => {
:settings => {
:defaults => {
- :shared_buffers => "10GB",
- :work_mem => "160MB",
- :maintenance_work_mem => "20GB",
+ :work_mem => "300MB",
+ :maintenance_work_mem => "10GB",
:random_page_cost => "1.5",
:effective_cache_size => "60GB",
- :fsync => "off"
+ :fsync => "on"
}
}
},