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.
nid ----- Original Message ----- From: "Christopher Kings-Lynne" <[EMAIL PROTECTED]> To: "MK Spam" <[EMAIL PROTECTED]> Cc: <[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