A good read -- talks about PG8, but this stuff applies to all the PG7.x family as well:
http://www.powerpostgresql.com/PerfList/
And the google cache is:
http://66.102.7.104/search?q=cache:oSPFaX1IBowJ:www.powerpostgresql.com/PerfList/+&hl=en
And more
http://forums.devshed.com/archive/t-84334/PostgreSQL-Performance-Resources
Very useful stuff, Martin. many thanks for those links!
Sean K Beardie
Sean K Beardie
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