Database performance tuning¶

• The PostgreSQL servers running VegBIEN on nimoy and vegbiendev have been tuned to run faster by caching more of the database in memory
• We are following the advice at Tuning Your PostgreSQL Server
• Still, there is a 10-50x slowdown when running PostgreSQL on a virtual machine instead of a host machine, according to Edwin at iPlant