SUNScholar/Optimisations/Database

From Libopedia

Revision as of 21:56, 6 June 2015 by Hgibson (talk | contribs)

(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 "build.properties" and "postgresql.conf" files.

Check the relevant wiki 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=37900"