"Victoria Parsons" <victoria.parsons at streamshield.com> 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)