> 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.
Try upgrading to PostgreSQL 7.4 and use the new pg_autovacuum daemon.
This daemon will monitor your tables and vacuum and analyze whenever
In response to
pgsql-performance by date
|Next:||From: Christopher Browne||Date: 2003-11-25 04:08:08|
|Subject: Re: [HACKERS] More detail on settings for pgavd?|
|Previous:||From: Nid||Date: 2003-11-25 03:05:56|
|Subject: Re: Where to start for performance problem?|