I've been digging around in the code and found where we are executing the
VACUUM command.  VACUUM ANALYZE is executed every 15 minutes.  We haven't
tried VACUUM FULL ANALYZE.  I think I read that using FULL is a good idea
once a day or something.  Just doing a VACUUM ANALYZE doesn't seem to be
preventing our problem.  Thank you for the responses.


----- Original Message ----- 
From: "Christopher Kings-Lynne" <[EMAIL PROTECTED]>
Sent: Monday, November 24, 2003 7:13 PM
Subject: Re: [PERFORM] Where to start for performance problem?

> > The archives of this list provides many ideas for improving performance,
> > but the problem we are having is gradually degrading performance ending
> > in postgres shutting down.  So it's not a matter of optimizing a complex
> > query to take 5 seconds instead of 60 seconds.  >From what I can tell we
> > are using the VACUUM command on a schedule but it doesn't seem to
> > prevent the database from becoming "congested" as we refer to it.  :]
> Our busy website has a cronjob that runs VACUUM ANALYZE once an hour
> (vacuumdb -a -q -z).
> Have you tried going 'VACUUM FULL ANALYZE' (vacuumdb -a -q -z -f)
> instead of a dump and reload?
> Chris

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to