On Fri, Mar 6, 2015 at 5:59 AM, pinker <pin...@onet.eu> wrote: > I have deleted a large number of records from my_table, which originally > had > 288 MB. Then I ran vacuum full to make the table size smaller. After this > operation size of the table remains the same, despite of the fact that > table >
If your remaining records were in say, block 2 and block 10000, then the blocks in between won't be returned to the system. You could achieve your "fix" by running cluster on the table, which will rewrite the table in-place. There are also scripts out there that do in-place compaction by running targeted updates and vacuum commands to get the empty pages at the end of the files truncated off the file.
