Admin Module page - high CPU, slow on PostgreSQL

Posted by stodge on June 30, 2009 at 1:04pm

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?

Comments

Want to help fix the problem?

Posted by Josh Waihi on July 7, 2009 at 5:27am

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.