28 Jul
2007
28 Jul
'07
2:13 p.m.
On 25/07/07, Christopher Schmidt <crschmidt(a)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.
--
Earle Martin
http://downlode.org/
http://purl.org/net/earlemartin/