On 25/07/07, Christopher Schmidt crschmidt@crschmidt.net wrote:
As Bob mentioned, the indexes are Serious Business: if a small section of query log from the site can be looked at, so that the queries can be 'explain analyze'd to check for sequential scans -- especially on the metadata table, which is likely > 1mil rows if it's anything like boston -- and indexes added.
Well, London.og is back up, and every now and then, so is the load. I think the problem is definitely one to do with the database; as soon as a few wiki.cgi's start being run simultaneously, we start getting Postgres' "postmaster" process running continuously and taking up 95% of CPU.
Paul, could you grant me access to the Postgres log so I can follow Christopher's suggestion?
Thanks,
Earle.