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.
--
Bob Walker
http://london.randomness.org.uk/
For great beery Justice!