"Victoria Parsons" <[EMAIL PROTECTED]> writes: > Has anyone else found that they need a vacuum full to keep their > replication, and/or general postgres use up to speed? Have I > mis-understood the use of vacuum full, and does it do more than just > recover disk space? Next time it goes wrong I will do vacuum full on > a table at a time to see if I can narrow down the culprit.
We *never* run a VACUUM FULL on a whole database; just occasionally on some very carefully selected table. Definitely you should narrow it down, and run VACUUM FULL ANALYZE on each table to see where you get a huge reclaiming of space. By all means, report back on your findings, that may help us help you, and help others, as well... -- select 'cbbrowne' || '@' || 'ca.afilias.info'; <http://dba2.int.libertyrms.com/> Christopher Browne (416) 673-4124 (land) _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
