I would like to get some idea about 'database_engine_option_pool_size' and 'database_engine_option_max_overflow' settings. We seem to hit both of these limits whenever a user runs a large workflow with following error:
{{{ TimeoutError: QueuePool limit of size 40 overflow 50 reached, connection timed out, timeout 30 }}}
These limits are not reached for regular (non-workflow) galaxy jobs. Any help on optimum values for these settings or performance tuning for workflow runs would be appreciated.
Version Info: CentOS 5.7, PostgreSQL 8.4.9, Python 2.6.6, Galaxy revision 26920e20157f.
-- Thanks, Shantanu