Philip Warner <pjw@rhyme.com.au> writes:
> Is there any way (other than VACUUM FULL) to recover the current lost space?
Probably not. Plain VACUUM will reclaim any empty pages it happens to
see at the end of the table, but without a VACUUM FULL you won't get any
proactive effort to make the end-pages empty.
regards, tom lane