Postgres Tuning Guide

Postgres Tuning Guide

by Martín Langhoff -
Number of replies: 2
In reply to Martín Langhoff

Re: Postgres Tuning Guide

by Sean Keogh -
Very useful stuff, Martin.  many thanks for those links!


Sean K Beardie
In reply to Martín Langhoff

Re: Postgres Tuning Guide

by Pim Koeman -

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