SUNScholar/Optimisations/Database

From Libopedia

Revision as of 09:39, 1 August 2014 by Hgibson (talk | contribs) (Created page with "<center> '''Back to Optimisations''' </center> *Increase connection pool parameters The following db connection parameters are used: max_connec...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to search

Back to Optimisations

Increase connection pool parameters

The following db connection parameters are used:

max_connections = 200
max_idle_connections = 400

These paremeters are set in the "dspace.cfg", "build.properties" and "postrgresql.conf" files. Check the relevant guide sections for more details.

Fix "browse index" configuration to reduce the PostgreSQL database server query load.

http://wiki.lib.sun.ac.za/index.php/SUNScholar/Browse_Indexes

Vacumn the database regularly

http://wiki.lib.sun.ac.za/index.php/SUNScholar/Daily_Admin

Retrieved from "http://wiki.lib.sun.ac.za/index.php?title=SUNScholar/Optimisations/Database&oldid=28405"