Thu Mar 22 12:28:03 PDT 2007
- Previous message: [Slony1-general] Vacuum full required?
- Next message: [Slony1-general] Vacuum full required?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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)
- Previous message: [Slony1-general] Vacuum full required?
- Next message: [Slony1-general] Vacuum full required?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list