https://redmine.dataone.org/https://redmine.dataone.org/favicon.ico2013-10-22T00:43:12ZDataONE TasksInfrastructure - Task #4106: Configure PostgreSQL memory on the CNs to accommodate large getLogRecords() callshttps://redmine.dataone.org/issues/4106?journal_id=175062013-10-22T00:43:12ZChris Brumgardchrisbrumgarddataone@gmail.com
<ul></ul><p>Chris,</p>
<p>This should be easy enough to do. </p>
<p>1) When is the upgrade of Metacat to 2.2.2 planned?<br>
2) Which set of CN will this affect? If this is the prod boxes, I only have sudo privileges on the orc node. I'm not suppose to have sudo privileges on any of the prod boxes after our security discussion a few weeks ago.</p>
Infrastructure - Task #4106: Configure PostgreSQL memory on the CNs to accommodate large getLogRecords() callshttps://redmine.dataone.org/issues/4106?journal_id=177072013-11-01T14:21:24ZChris Brumgardchrisbrumgarddataone@gmail.com
<ul></ul><p>For configuring the work memory, should work memory be always set to 10GB / max_connections or 1/3 RAM / max_connections. </p>
Infrastructure - Task #4106: Configure PostgreSQL memory on the CNs to accommodate large getLogRecords() callshttps://redmine.dataone.org/issues/4106?journal_id=177082013-11-01T14:42:23ZChris Jonescjones@nceas.ucsb.edu
<ul></ul><p>Chris - the point is to allow plenty of work_mem for sorting operations, etc., and so in lieu of the VMs total RAM, 25% to 33%, divided by max_connections, would be a decent work_mem setting. However, for VMs with little memory (say 4GB), I'd be more conservative and use 15-20%.</p>
Infrastructure - Task #4106: Configure PostgreSQL memory on the CNs to accommodate large getLogRecords() callshttps://redmine.dataone.org/issues/4106?journal_id=177512013-11-05T21:02:09ZChris Brumgardchrisbrumgarddataone@gmail.com
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Closed</i></li><li><strong>% Done</strong> changed from <i>0</i> to <i>100</i></li><li><strong>translation missing: en.field_remaining_hours</strong> set to <i>0.0</i></li></ul>