Can i remove/reduce 35 1Gig files?

[marco]

Hi

I'm trying to free up space on and clean up my hard drive, and i have just purged 7mil hands or so.

When i do a defrag, i get 35 postgres files listed that
1. can't be defragged
and
2. are 1gig large.

I've recently switched sites, and i don't care about keep any data older than 2 months, so is there a way to completely remove all those hands/files?

I was going to Vacuum/analyze tonight, but can i do more?

Thanks

marco

[_Loki_]

Hi Marco - There's plenty you can do, but first...

###
Which folder (or folders) are these 35 x 1Gb files in ? (give the path)
What are these files called ?

###
When you defragged...
Were you out of HM ?
& did you turn off the postgreSQL service ?

[marco]

Hi Loki

I have 74 files located in c:\Program files\PostgreSQL\8.3\data\base\17178 which will not defrag, due to "Not Enough Space" .

There's actually more like 40 of them which are reported as being exactly 1.00GB in size, the rest are all between 90 - 900MB.

I was out of HEM and did turn off the service before trying this.

Also, i am running 8.3, and i see 8.4 is available. Do i need to upgrade before continuing?



Thanks again.

Mark

[_Loki_]

Hi Mark

Stay with 8.3

1] go into pgAdmin & see which DB is 17178...
In pgAdmin click on each DB you've got in the left pane & find the one that's got OID 17178 written in the right pane
What's that DB named in the left pane ?
Is it one you're using ?
How many DB's you got in pgAdmin III there ?
Maybe there's one or two you can delete
[don't mess with the one named 'postgres' nor the one you're using

2] Go here in explorer:
C:\Program Files\PostgreSQL\8.3\data\pg_log
How big is the pg_log folder ?
You can delete EVERYTHING in that folder, but leave the empty folder & stop it making future logs:
FAQ - Hold'em Manager Poker Tracking Software :: Large Log Files (http://faq.holdemmanager.com/questions/85/Large+Log+Files)

3] Download this free little program & see what you have used up your disk space on - maybe you can 'trim' some stuff
WinDirStat - Windows Directory Statistics (http://windirstat.info/) [not compatible with win7]

4] To remove progs use this:
Revo Uninstaller - Free software downloads and software reviews - CNET Download.com (http://download.cnet.com/Revo-Uninstaller/3000-2096_4-10687648.html)

5] Download & run ccleaner to remove excess temp files & various caches:
CCleaner - Free software downloads and software reviews - CNET Download.com (http://download.cnet.com/ccleaner/)

Start with that stuff - more to come in a while

[_Loki_]

are you xp 32bit ?

[_Loki_]

When you vacuum analyse your DB you'll maybe shrink postgreSQL enough to be able to properly defrag those stubborn files

Also you could re-index, which removes dead rows from the pg tables. This will speed up access to the DB & should prevent lag on a big DB, but I doubt that it saves much space on recent (after version 7.4) versions of postgreSQL. Probably a good idea though after a purge...

This is a quite good free defragger from IObit
Smart Defrag - Free software downloads and software reviews - CNET Download.com (http://download.cnet.com/Smart-Defrag/3000-2094_4-10759533.html)

I use 'MyDefrag' which is also free & is better IMO, but it's tricky to set up in the best way - requires study

Here's the FAQ on Revo - couldn't find it earlier:
FAQ - Hold'em Manager Poker Tracking Software :: Using Revo Uninstaller (http://faq.holdemmanager.com/questions/126/Using+Revo+Uninstaller+)

[marco]

Hey

the db files in question are in the holdem manager DB. there are only 3 db's in there, an old pokertracker one i can kill, and the postgre one.

I've removed the log files and have ccleaner. This HEM DB folder ( 17178) accounts for 71GB on my computer ( as per winDirStat).

I assume these db files are all the old hands i've imported(?) is there a way i can remove them? Or am i way off on tis assumption?

Mark

[marco]

are you xp 32bit ?

yes

[_Loki_]

your wording worries me...

There are TWO programs we're talking about here...
The 71Gb is in the HEM DB folder or is it in postgresql ???
I would have thought you were talking about here:
1] C:\Program Files\PostgreSQL\8.4\data\base\17178
But maybe you're talking about here:
2] C:\HMArchive\2010\06\01 (made up numbers)

You could move all your old HH's off your HDD from 2] above onto a flash drive or something (these are .txt files in your HMArchive)

Why not get rid of some old progs & videos etc ?

###
This PT DB is what ? A HH file or is it in postgreSQL as a DB ?

[marco]

sorry for the confusion.

I am talking about C:\Program Files\PostgreSQL\8.4\data\base\17178. That is the DB I named "Holdem Manager", cause its the one that HEM uses.

So, i vacuum analyzed that db, and it shrank from 71 GB to 67 GB.

So just to be clear, the db i'm presently using for HEM is huge ( the above one), and at this point, I just want to delete like 90% of it. Can i simply create a new db and delete the present one? Then when I have a new blank one, could I just import the archived files which i want to keep?

The only issue with this is, i will lose all the notes I made on players. Can i keep those some how?

Mark

[fozzy71]

sorry for the confusion.

I am talking about C:\Program Files\PostgreSQL\8.4\data\base\17178. That is the DB I named "Holdem Manager", cause its the one that HEM uses.

So, i vacuum analyzed that db, and it shrank from 71 GB to 67 GB.

So just to be clear, the db i'm presently using for HEM is huge, and at this point, I just want to delete like 90% of it. Can i simply create a new db and delete the present one? Then when I have a new blank one, could I just import the archived files which i want to keep?

Yes

Create a new DB and import from your archives as wanted. Your \HMArchive is likely not in your \Holdem Manager directory. We normally suggest you use C:\HMArchive, but you may have put it anywhere.

To verify the location: Options > Configure Auto Import Folders > Edit > Archive Folder: ___________________

FAQ - Hold'em Manager Poker Tracking Software :: Warning: You have XXX Hand History Files in your Auto Import Folders (http://faq.holdemmanager.com/questions/119/Warning:+You+have+XXX+Hand+History+Files+in+your+A uto+Import+Folders)

The archive should be organized by \Month\DayOfMonth (example: D:\HMArchive\2009\07\31).



The only issue with this is, i will lose all the notes I made on players. Can i keep those some how?

Mark

backup everything manually before you delete the database:

Find and backup your \HMArchive folder. Your \HMArchive is likely not in your \Holdem Manager directory. We normally suggest you use C:\HMArchive, but you may have put it anywhere. To verify the location: Options > Configure Auto Import Folders > Edit > Archive Folder: ___________________

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

Make sure you export any custom HUD layouts to your \Config folder and copy it for a backup. FAQ - Hold'em Manager Poker Tracking Software :: Import / Export HUD Layout (http://faq.holdemmanager.com/questions/46/Import+%7B47%7D+Export+HUD+Layout)

and finally:

Export your hands and then open the new database and import them into that - FAQ - Hold'em Manager Poker Tracking Software :: How to Import & Export Hands (http://faq.holdemmanager.com/questions/98/How+to+Import+%26+Export+Hands)

Once the Hands are imported you can import the Tourney Results and Bonuses/Rakeback and Notes

[marco]

thanks,

I've done that and it all seems to work. I free'd up 70 GB on my HD.

Thanks again for the help!

Mark