Difference between revisions of "SUNScholar/Optimisations/Database"
Jump to navigation
Jump to search
m |
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 | + | These paremeters are set in the "build.properties" and "postgresql.conf" files. |
Check the relevant wiki guide sections for more details. | Check the relevant wiki guide sections for more details. | ||
Revision as of 21:56, 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 "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
