PDA

View Full Version : Disk Space not returning



Luca2903
12-19-2008, 04:04 AM
Hi, I'm using HM 1.06.03h in trial mode (15days). - I use vista 32bits

I imported some hh that I played at FTP, then took note of the size of the database in the folder PostgreSQL. Then imported some observed hand histories from FTP, and took note of the size again.

Later, I decided do purge, and delete (completely) the observed hands.
Vaccum, analize etc twice.

I'm pretty sure that I fully purged/deleted all of them.

But although the the database obviously got smaller, it didn't go back to the original size, when I only had the hands that I played.

Is this normal? Can you guys please help me, get the space back, without creating another dabatase, or something like this?

This is because, althouth the program can handle large databases, I just don't have disk space. So I want to import some observed hands at some time, then completely delete them, to import nem observed hands another time.

Hope I'm clear guys, thanks for the time.

Luca2903
12-19-2008, 04:41 AM
Hey guys, I updated to 1.07, checked to see if there was any observad hands (nothing found), vacuum again, but the space, is still the same.

Sorry for any inconvenience.

Al1
12-19-2008, 09:25 AM
You can delete everything which is in the pg_log folder from postgreSQL.
Generally here (for XP): C:\Program Files\PostgreSQL\8.3\data\pg_log

Luca2903
12-19-2008, 09:56 AM
You can delete everything which is in the pg_log folder from postgreSQL.
Generally here (for XP): C:\Program Files\PostgreSQL\8.3\data\pg_log

Hi Al, thanks for the fast tip.

Unfortunately, there was nearly nothing there (30mb), but with you people help, I'm sure we'll figure this out.

PS: There is algo a folder "pg_xlog" (128mb) - but it's also very small.

Thanks anyway man!

Al1
12-19-2008, 10:01 AM
What's the size of the surplus?

p.s.: Don't delete other things in the postgreSQL!

Luca2903
12-19-2008, 10:09 AM
What's the size of the surplus?

p.s.: Don't delete other things in the postgreSQL!

Sorry Al, this word "surplus", is it some kind of american slang kkkk ?

I'm brazilian, and couldn't find this "file".

:P

Luca2903
12-19-2008, 10:10 AM
Ps: 95% of the size of PostgreSQL, is in the data folder \data\""base"".

Al1
12-19-2008, 10:19 AM
My DB has a little less than 3Mio hands and the base folder is around 12Go.

What's the size of your base folder and how many hands do you have: http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=19

Luca2903
12-19-2008, 10:59 AM
Right now - 122784 hands - 2,07gb

Before I import 1mi observed hands and deleted them, I had the same 122784 hands, and the folder postsql had 1gb.

Luca2903
12-19-2008, 11:00 AM
After the 1st import of this 122k hand (1gb), I purged only the hh, but kept the stats, and the whole folder got to 857mb.

morny
12-19-2008, 11:14 AM
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
12-19-2008, 11:26 AM
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
12-19-2008, 11:36 AM
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
12-19-2008, 01:17 PM
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
12-19-2008, 01:34 PM
Yeah sorry i was thinking of a defrag, stopping the postgreSQL service wont work obviously.

Ill check this with Roy

Luca2903
12-20-2008, 01:02 PM
up

Luca2903
12-22-2008, 05:32 PM
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
12-29-2008, 02:49 AM
up

morny
12-29-2008, 11:06 AM
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/showthread.php?t=5197&page=2

Rvg72
12-30-2008, 02:14 AM
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

Luca2903
12-30-2008, 02:23 AM
Ok, but how do I get the space back after deleting/purging the hhs that I don't want anymore?

Thanks a lot guys.

Rvg72
12-31-2008, 08:32 PM
Well this is where a Full Vacuum should reclaim the space. I have seen it before when the space was not reclaimed right away but after rebooting it was showing up properly under My Computer.

Roy