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/Amsterdam)
het volgende geschreven:
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 for the next 40 hours or so:
10-07-00:NOTICE: Pages 961913: Changed 76279, Empty 0; Tup 3620753:
Vac 272006, Keep 0, UnUsed 290.
10-07-00: Total CPU 52.00s/18.71u sec elapsed 428.71 sec.
then half an hour later:
10-07-30:NOTICE: Pages 962010: Changed 604, Empty 0; Tup 3622733: Vac
241, Keep 0, UnUsed 270468.
10-07-30: Total CPU 45.22s/6.00u sec elapsed 216.26 sec.
and the same size 40 hours later:
11-23-30:NOTICE: Pages 962010: Changed 186, Empty 0; Tup 3665890: Vac
3, Keep 0, UnUsed 228083.
11-23-30: Total CPU 45.48s/5.03u sec elapsed 223.93 sec.
It may be a different table, but the messageblks toast table is
usually the largest. Perhaps it's just a bad example.
Is it still growing?
If so, can you send some logs from a time where it grew, and send me
the output of 'ls -lRt' on the data directory and of 'select
oid,relname from pg_class' (SQL).
enjoy your holiday :)
Good so far...
----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.B.N. 75 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 03 5330 3172 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
Met vriendelijke groet,
Roel Rozendaal
_________________________
R.A. Rozendaal
ICT Manager
IC&S
T: +31 30 2322878
F: +31 30 2322305
www.ic-s.nl
