"Neuber, Dirk" <dirk.neuber@xxxxxxxxx> writes: > One last question. After using vacuumlo the file size of 16385/2613 is > still the same as before. > It seems the content has been removed but the file itself hasn't been > compacted. > Is there an option or tool which can do this as well ? Yeah, you still need to apply VACUUM FULL to bring the physical file size down. (Ordinary VACUUM mostly just recycles space within the file --- it can truncate the file if the end pages are empty, but it won't move data around to make that possible.) regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
