Christopher Browne cbbrowne at ca.afilias.info
Thu Mar 22 12:28:03 PDT 2007
Joseph Shraibman <jks at selectacast.net> writes:
> You need to run select pg_relation_size('tablename') to see how much
> space vacuum full is reclaiming.
>
> Also remember that vacuum full does not reclaim space in the
> indexes. If you don't REINDEX you might end up with indexes that are
> larger than the table itself.

That's actually not a problem in this case; pg_listener doesn't have
any indices, so there's nothing to bloat.
-- 
select 'cbbrowne' || '@' || 'ca.afilias.info';
<http://dba2.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)


More information about the Slony1-general mailing list