Disk Space not returning

[Luca2903]

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]

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]

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]

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]

What's the size of the surplus?

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

[Luca2903]

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]

Ps: 95% of the size of PostgreSQL, is in the data folder \data\""base"".

[Al1]

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/afm....aspx?faqid=19

[Luca2903]

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]

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.