Hi philip,
well it seems the growing has stoppen - the database has grown from 7.5
to 8.7 Gb in a few days but has been stable since. Thanks for your help
- i'll be sure to contact you if it starts growing again ;)
regards roel
Philip Warner heeft op dinsdag, 14 jan 2003 om 06:29 (Europe/Am
At 09:30 AM 13/01/2003 +0100, Roel Rozendaal - IC&S wrote:
here are the logs of two days of vacuuming - hope it can help!
Can you let me know which file(s) are growing? It looks from these logs
like the messageblks toast table grew slightly at the start of the day,
then remained the same size
Hi philip,
here are the logs of two days of vacuuming - hope it can help!
enjoy your holiday :)
regards roel
Philip Warner heeft op vrijdag, 10 jan 2003 om 13:19 (Europe/Amsterdam)
het volgende geschreven:
At 05:14 PM 9/01/2003 +0100, Roel Rozendaal - IC&S wrote:
In spite of these measure
At 05:14 PM 9/01/2003 +0100, Roel Rozendaal - IC&S wrote:
In spite of these measures the database is growing again - at a rate of
about 600 Mb /day. Any ideas on attacking this problem?
Can you send me a (compressed) set of logs of the VACUUM VERBOSE output for
a typical cycle (presumably 24 h