PostgreSQL: 17.2GB, PTbackup: 400mB?

[psl86]

How come is my postgreSQL folder that big? I just purged every other observed hands, and all that is left is my own 100 000ish hands.. If I backup my PTdatabase, the file is only 400MB.. DOesnt make any sense..

[ptrack pat]

#1. Did you do a FULL vacuum/analyze after you purged all these hands? If not, you need to.

#2. The backup file is a compressed file, that's why it's so much smaller.

[psl86]

I didnt vacuum afterwards...Ill do that first.

[psl86]

yeeeeeeeeeeeeees............... 400mb of free space..