Project

General

Profile

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