Hi,
Another theory question -
PostgreSQL documentation says that - "There are two variants of VACUUM: standard VACUUM and VACUUM FULL. VACUUM FULL can reclaim more disk space "
select pg_total_relation_size('myt');;
pg_total_relation_size
------------------------
65536
(1 row)
accounts=> vacuum myt;
VACUUM
accounts=> select pg_total_relation_size('myt');;
pg_total_relation_size
------------------------
16384
(1 row)
accounts=> vacuum full myt;
VACUUM
accounts=> select pg_total_relation_size('myt');;
pg_total_relation_size
------------------------
0
(1 row)
Regards,