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.

Thanks,
Craig