We were running vacuum and vacuum full daily without the vaccum analyze on weekends. After about 2 weeks the master database would slow down. How often do you run VACUUM or are you using the autovacumm daemon.
Andrew Sullivan wrote:
On Tue, Aug 28, 2007 at 03:40:03PM -0400, John R Allgood wrote:
lot of activity as compared to the other databases. We run VACUUM at
midday VACUUM FULL at night, VACUUM ANALYZE on weekends.
If you are running VACUUM often enough, then you should _never_ need
VACUUM FULL. And weekly VACUUM ANALYSE is probably too infrequent.
A