Disk Space not returning

[morny]

If you follow this FAQ (for illustration only) http://www.holdemmanager.net/faq/?f=12 and tell me how many databases are there and what there names are please

This time before doing a vacuum go to Programs > PostgreSQL > Stop Service and then try a vacuum and see if it makes a difference, weird it isnt shrinking after deleting the HH

[Luca2903]

I have only one database, called HoldemManager, i'll do what you said, and then get back here.

PS: It shrinked when I deleted the observed hands, but not totally as it "should".

Thanks guys.

[Luca2903]

hey Morny, when I stop the service, I couldn't vacuum using the pgadmin or the HM. Is says that it's not possible to make a connection.

[Luca2903]

To be sure, I got another computer (laptop) and did the following process:

1 - Imported 120k hands
2 - Options - Purge All
3 - Vacuum twice

Result: Have NO hh at all at the computer, but the folder "base" still has a decent size =(

[morny]

Yeah sorry i was thinking of a defrag, stopping the postgreSQL service wont work obviously.

Ill check this with Roy

[Luca2903]

up

[Luca2903]

Hi guys, don't wanna be a pain in the ass, I'd just like to know, if there is anyone searching any solution for this, or not.

Thanks for the great support.

[Luca2903]

up

[morny]

Sorry about the delay, must have missed this one, ill ask Roy about this now and hell respond here soon http://www.holdemmanager.net/forum/s...?t=5197&page=2

[Rvg72]

A vacuum won't do anything immediately after a large import. To understand how it works you need to first understand how the DB works. Basically, whenever you update a row or delete a row in any table it actually just marks it for deletion. Say one row in the db is updated 20 times there will actually be up to 20 copies of the row taking up disk space. A full vacuum will remove the 19 old copies of that row.

When you do a big import for the very first time there will be almost no "dead space" and therefor the vacuum will do almost nothing

Roy