The following changes have been made to our production PostgreSQL GUCs since starting to work with Marmotta.
- Enabled logging of slow statements, currently > 200ms
- Set shared_buffers to 3072MB, where the system has 7GB real memory (and the system was upgraded to a c3.xlarge Amazon EC2 instance)
- Increased maintenance_work_mem to 100MB
- Turned off synchronous_commit
- Turned on logging of queries that create temporary files (log_temp_files).
- Set random_page_cost to 1.5 because we have SSD drives
- Set work_mem to 38MB