We applied every postgres tuning trick in the powerpostgresql article, it works very well !! our system is now about 400% faster
Even more postgres performance ?
- Run a full VACUUM every night using cron using the command
vacuumdb --full --dbname=<name_of_moodle_database>
Warning : tables will be exclusively locked !! (some downtime may occur) - Reindex your database tables !!!
Run the SQL command
REINDEX DATABASE <name_of_moodle_database>
By frequent reindexing we reduced the database diskspace by half !!!
(Our database is approx 2 gigabyte, now reduced to 980Mb !!)
Kind regards,
Pim Koeman, Wittenborg University, Deventer, The Netherlands
www.wittenborg-university.com