- Create table vacuum_table CREATE TABLE
- Insert 100000 records into vacuum_table INSERT 0 100000
- After insert 100000 records table size is: 5914624
- Check autovacuum: AUTOVACUUM is off
- Update table vacuum_table UPDATE 100000
- After update 100000 records table size is: 14032896
- Run long live transaction pid: 25211
- Run VACUUM FULL VACUUM
- After VACUUM FULL table size is: 5890048
- Killing long live transaction
- Run VACUUM FULL VACUUM
- After VACUUM FULL table size is: 5890048
- Create table vacuum_table CREATE TABLE
- Insert 1000000 records into vacuum_table INSERT 0 1000000
- After insert 1000000 records table size is: 58769408
- Check autovacuum: AUTOVACUUM is off
- Update table vacuum_table UPDATE 1000000
- After update 1000000 records table size is: 140017664
- Run long live transaction pid: 26649
- Run VACUUM FULL VACUUM
- After VACUUM FULL table size is: 58736640
- Killing long live transaction
- Run VACUUM FULL VACUUM
- After VACUUM FULL table size is: 58736640