Nid wrote:
> 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
necessary.
Chris