Admin Module page - high CPU, slow on PostgreSQL
stodge - June 30, 2009 - 13:04
I guess Drupal's PostgreSQL support isn't that great in the module page. Just loading the page is significantly quicker when using mySQL. Enabling or disabling a module can take up to a minute in PostgreSQL, while mySQL completes the task in seconds. PostgreSQL hits 94% CPU usage while mySQL tops out at arounf 30% with httpd hitting 40+%. Huge difference. Any ideas?
Want to help fix the problem?
There is this issue for Drupal 7, http://drupal.org/node/343082 - I am interested in making PostgreSQL faster for Drupal. see http://geek.joshwaihi.com/content/drupal-code-sprints-postgresql
thanks to catalyst.net.nz for letting me contribute work time to Drupal.