Christopher Browne wrote:
Craig James <[EMAIL PROTECTED]> writes:
Questions:
1. Does Slony run vacuum every hour?
It shouldn't be exactly hourly, I wouldn't think; Slony-I *does* have
a cleanup thread which runs periodically.
In src/slon/slon.h, the #define SLON_CLEANUP_SLEEP, with default of
600 (indicating 600 seconds), combined with SLON_VACUUM_FREQUENCY
(default 3) combine so that I'd expect to see the cleanup thread
vacuum certain Slony-I tables roughly every 1/2 hour.
I say "roughly" because there is some conscious use of random values
to make it vary a bit.
2. If so, is it a requirement?
Probably. If slon doesn't vacuum, and you don't have AutoVacuum doing
vacuums, and you don't have some custom scripts doing vacuums, then
there are a number of tables that would eventually bloat up into
ridiculous size.
Does Slony only vacuum the tables you mention, or does it launch a general
VACUUM of the whole database? In my case, a general VACUUM statement is
inappropriate - most of the database is static.
Thanks,
Craig
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
