Reputation: 9550
It's a CentOS server (I don't know the specs) and just before anybody states the obvious, keep in mind these mitigating factors:
Here's a graph of the server load:alt text http://img96.imageshack.us/img96/6352/loady.gif
UPDATE (2010/9/15): We never found a server or config cause to this, but our application was optimized and the load is back to acceptable levels at the same usage:
Upvotes: 1
Views: 414
Reputation: 28084
Not only should you vacuum, but also vacuum analyze, and reindex (at least once a month), since indexes are not vacuumed.
May I also suggest that your piece of software is just so good that you gain more users over time?
Upvotes: 1