On Fri, Mar 6, 2015 at 5:59 AM, pinker <pinker@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.
