[InterMine Dev] Fwd: Postgres Server settings
gail.binkley at stanford.edu
Fri Aug 2 17:45:50 BST 2013
Didn't hear back from anyone on the InterMOD mailing list so I thought I'd try the dev list. Thanks, Gail
----- Forwarded Message -----
From: "Gail Binkley" <gail.binkley at stanford.edu>
To: "InterMOD Mailing List" <mods at intermine.org>
Sent: Monday, July 29, 2013 2:43:45 PM
Subject: Postgres Server settings
We are setting up a new server for Intermine and whenever that happens I like to revisit the database parameter settings. Are the database recommendations given at http://intermine.readthedocs.org/en/latest/system-requirements/software/postgres/postgres/ still current/valid? Since this server will contain ENCOD-like data, what parameter settings are used by ModMine?
If folks are not using the recommended shared_buffers = 150MB what are you using? I configuredYeastmine some years ago and am wondering with the increase in data and usage whether it would be good to increase some of these parameters.
Thanks for sharing your experiences,
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the dev