Re: new full vacuum doesn't work

Pavel Stehule <pavel.stehule@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