On Wed, 25 Jul 2007, Paul Makepeace wrote:
I'm looking for a response along the lines of,
"We will test and thrash a local instance of OG London with FastCGI and Apache Bench on our home boxen by date YYYY-MM-DD. At this point we'd like to set up a test instance on stix on date YYYY-MM-DD, and let it bake for a week. If that's OK, we'll move the install over on YYYY-MM-DD."
in which case we need more info . give us specs of the box its on. what access numbers are like currently. what versions of postgres and apache.
also, is there iowait on the box.
is the database being vacuumed? (just to make sure) has the database setup been tweaked.
not that i really care but no one else seems to have these issues. well boston may have done but then crschimdt implemented mod_perl, memcached and better indexes and indeed uses mysql i think.
ive certainly seen that some workloads dont cope very well on postgres.