PDA

View Full Version : huge postgreSQL file



bingbang
04-27-2010, 11:29 PM
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
04-28-2010, 12:28 AM
Don't delete anything in the data/base folder.
That's your actual database.


Read: http://forums.holdemmanager.com/manager-general/11194-top-10-hem-performance-increase-tips.html

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

Arizona Willie
04-28-2010, 12:15 PM
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
04-28-2010, 02:02 PM
yes I did the manual vacuum and re-indexed, but that only gave me an extra 1/2 a gig :(

morny
04-28-2010, 10:37 PM
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 (http://faq.holdemmanager.com/questions/75/Create+%7B47%7D+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
http://faq.holdemmanager.com/images/notes-02.jpg

Export Your Bonuses and Rakeback - Options > Rakeback & Bonuses http://faq.holdemmanager.com/images/rakeback-bonuses-01.jpg

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

http://faq.holdemmanager.com/images/tourney-data-view-01.jpg

bingbang
04-28-2010, 11:36 PM
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
04-29-2010, 04:06 AM
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
04-29-2010, 07:27 PM
Yes, I'm just curious as to how much the size of one's DB can be diminished through this process

netsrak
04-30-2010, 04:44 AM
I would roughly calculate with 10 GB for 1M hands.

Deragen
05-01-2010, 06:17 AM
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 (http://faq.holdemmanager.com/questions/197/Purge+Hands)
Then I proceeded Manual Vacuum/full following
FAQ - Hold'em Manager Poker Tracking Software :: Vacuum Analyze Database (http://faq.holdemmanager.com/questions/88/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 ?

_Loki_
05-01-2010, 12:54 PM
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 (http://faq.holdemmanager.com/questions/197/Purge+Hands)
Then I proceeded Manual Vacuum/full following
FAQ - Hold'em Manager Poker Tracking Software :: Vacuum Analyze Database (http://faq.holdemmanager.com/questions/88/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.

What is the name of the DB you did the vacuum/full on ?
Open HM & see what you have called the DB you play poker with
Close HM
then in pgAdminIII look for the same name

Deragen
05-01-2010, 03:22 PM
Thank you, Loki, I made a mistake not waiting for the end of vacuuming ( I exited when OK button is still grey)