[OGDev] URGENT Re: [OpenGuides-Dev] OG performance

[Earle Martin]

On 25/07/07, Christopher Schmidt <crschmidt at 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/