david.techer david.techer at davidgis.fr
Wed Sep 21 01:31:48 PDT 2011

Hi 

I've begun to test Slony 2.0.7 a couple days ago. 
I've read the Slony documentation and see on the source for
clean_thread.c for vac_frequency 

However, I've got a question 

What happens if I put both on master and slave 

1) 

 ALTER TABLE _mycluster.sl_event SET (autovacuum_enabled=off);
 ALTER TABLE _mycluster.sl_confirm SET (autovacuum_enabled=off); 
2) vac_frequency=3 or vac_frequency=0 ? 

For your information, I use PostgreSQL 8.4, Slony 2.0.7. Autovacuum
is on both master and slave. 
If I have understood, 

vac_frequency=0 implies that SLony will not used his "own"
maintenance operation and just do a analyze if required 
Let me know. 
-------------------------------------- Jean David TECHER davidgis.fr
-------------------------------------- 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20110921/bcd07769/attachment.htm 


More information about the Slony1-general mailing list