[InterMine Dev] Fwd: Postgres Server settings

Gail Binkley 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, 

Gail Binkley 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.intermine.org/pipermail/dev/attachments/20130802/e900132b/attachment.html>

More information about the dev mailing list