Pavel Stehule <pavel.steh...@gmail.com> wrote: > I am testing vacuum changes, and I found some strange behave:
Did you need "SET (fillfactor=100)" before vACUUM FULL? =# select * from pgstattuple('pgbench_accounts'); -[ RECORD 1 ]------+----------- table_len | 1365336064 tuple_count | 1000000 tuple_len | 121000000 tuple_percent | 8.86 dead_tuple_count | 0 dead_tuple_len | 0 dead_tuple_percent | 0 free_space | 1228669388 free_percent | 89.99 =# ALTER TABLE pgbench_accounts SET (fillfactor=100); ALTER TABLE =# vacuum full pgbench_accounts; VACUUM =# select * from pgstattuple('pgbench_accounts'); -[ RECORD 1 ]------+---------- table_len | 134299648 tuple_count | 1000000 tuple_len | 128000000 tuple_percent | 95.31 dead_tuple_count | 0 dead_tuple_len | 0 dead_tuple_percent | 0 free_space | 1840616 free_percent | 1.37 Regards, --- Takahiro Itagaki NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers