Craig James <craig_james at emolecules.com> writes:
> Christopher Browne wrote:
>> Craig James <craig_james at emolecules.com> 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.

Slony-I only vacuums the specific tables that it directly uses; it
will never (barring bugs, of course!) vacuum the entire database.
-- 
output = reverse("ofni.sesabatadxunil" "@" "enworbbc")
http://www3.sympatico.ca/cbbrowne/spiritual.html
"Bawden is  misinformed.  Common Lisp  has no philosophy.  We are held
together only by a shared disgust for all the alternatives."
-- Scott Fahlman, explaining why Common Lisp is the way it is....