"Neuber, Dirk" <dirk.neuber@barco.com> 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