Wed Sep 21 01:31:48 PDT 2011
- Previous message: [Slony1-general] PDF available for Slony 2.0.7 (English) and Slony-ctl 1.2.0 (French)
- Next message: [Slony1-general] Question about vac_frequency and autovacuum_enable for Slony 2.0.7 and PostgreSQL 8.4
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] PDF available for Slony 2.0.7 (English) and Slony-ctl 1.2.0 (French)
- Next message: [Slony1-general] Question about vac_frequency and autovacuum_enable for Slony 2.0.7 and PostgreSQL 8.4
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list