Vick Khera wrote > On Fri, Mar 6, 2015 at 5:59 AM, pinker < > pinker@ > > 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. I have tried many combinations of VACUUM, VACUUM FULL and CLUSTER after first failed VACUUM FULL and nothing works... -- View this message in context: http://postgresql.nabble.com/VACUUM-FULL-doesn-t-reduce-table-size-tp5840782p5841086.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
