huge postgreSQL file

[bingbang]

the 8.3\data\base file is 9Gigs. I just reformatted my cpu this month...

Previously, the file that gave me issues was the pg_log file. I followed your instructions to re-configure the postgresql.conf file, and since then I haven't had anymore large pg_log files.

Is there any way I can decrease the size of the base file? Is that my database? What happens if I delete those files, will HEM still have hands on my opponents, myself etc.?

[Patvs]

Don't delete anything in the data/base folder.
That's your actual database.


Read: http://forums.holdemmanager.com/mana...ease-tips.html

#8,9, 11 to gain more diskspace/ make the database smaller

[Arizona Willie]

Just yesterday I looked at my Postgres directory and it was 38.5 GB so I went through the purge / vacuum / analyze process and when done it was down to 21.4 GB.

I hadn't noticed any performance problem and when playing last night after doing the maintenance I didn't really see any difference. But it definitely knoced almost 20GB off my files.

[bingbang]

yes I did the manual vacuum and re-indexed, but that only gave me an extra 1/2 a gig

[morny]

Sometimes it needs a reboot to reclaim the extra space, try that, other than that the best way to shrink the database is exporting the hands, can you create a new database FAQ - Hold'em Manager Poker Tracking Software :: Create / Delete Database and reimporting the hands and then deleting the old database when your sure the new database has all the data

If your doing this you should also consider the following.

Export Your Notes


Export Your Bonuses and Rakeback - Options > Rakeback & Bonuses

Export any tourney summaries by selecting all your tournaments in the Data View Sub-Tab of the Tourney > Results Menu and choose Export Tourney Results and summaries

[bingbang]

Thank you for the suggestion. I have rebooted my cpu since then, however the size of my db has not decreased.

Regarding exporting and then reimporting, would the size of the DB not be the same after reimporting as it was before exporting?

[netsrak]

You need to create a new empty database to which you import the files.

After completion and everything running well you can delete the old database.

Btw: 20 GB is not that much for a database

[bingbang]

Yes, I'm just curious as to how much the size of one's DB can be diminished through this process

[netsrak]

I would roughly calculate with 10 GB for 1M hands.

[Deragen]

I have a big HM database (32 Gb), I purged 4 millions of old hands following
FAQ - Hold'em Manager Poker Tracking Software :: Purge Hands
Then I proceeded Manual Vacuum/full following
FAQ - Hold'em Manager Poker Tracking Software :: Vacuum Analyze Database
it was very fast (less than a minute) and the size hasn't decreased, rebooting didn't help. I use Postgres 8.3.

Unfortunately the hint to create new db, then export, doesn't work for me because I have only 6Gb of free space left on the hard disk.

So is there way to make vacuum really work ?