Difference between revisions of "SUNScholar/Optimisations/Database"
Jump to navigation
Jump to search
(Created page with "<center> '''Back to Optimisations''' </center> *Increase connection pool parameters The following db connection parameters are used: max_connec...") |
m |
||
| Line 7: | Line 7: | ||
max_connections = 200 | max_connections = 200 | ||
max_idle_connections = 400 | 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. | + | These paremeters are set in the "dspace.cfg", "build.properties" and "postrgresql.conf" files. |
| + | |||
| + | Check the relevant wiki guide sections for more details. | ||
*Fix "browse index" configuration to reduce the PostgreSQL database server query load. | *Fix "browse index" configuration to reduce the PostgreSQL database server query load. | ||
http://wiki.lib.sun.ac.za/index.php/SUNScholar/Browse_Indexes | http://wiki.lib.sun.ac.za/index.php/SUNScholar/Browse_Indexes | ||
*Vacumn the database regularly | *Vacumn the database regularly | ||
http://wiki.lib.sun.ac.za/index.php/SUNScholar/Daily_Admin | http://wiki.lib.sun.ac.za/index.php/SUNScholar/Daily_Admin | ||
Revision as of 21:55, 6 June 2015
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 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
