Huge Database Size 486 GB for 900k hands - Note Caddy Problem?

[KingDeva]

My database got yellow flagged in HEM2 for low disk space. I have a 1 TB HDD and my database is 900k hands. I have Note Caddy and Note Caddy Edge. I also had frequent problems with getting pop ups to open, would take 5 to 10 seconds and sometimes crash completely.

My computer is new 2014, 1 TB HDD, 12GB ram, i7 processor etc.

Why did my database get so large? It was 486 GB

I followed the instructions from here:

http://forums.holdemmanager.com/general-support/418351-db-way-too-large.html

"What you can do is:
Disable that flag + restart HM to stop Caddy
then open PGadmin, find your DB there and delete these 2 tables
notecaddy_data
notecaddy_scatter
After that do DB mainternance (vacuum full + analyze AND reindex full)
As you should understand, this will delete all Caddy notes from DB."

After doing this my database is now 3GB which seems normal. But the question is why was Note Caddy using 485 GB that seems obscene?

I now have Note Caddy disabled via the HUD settings as detailed in the instructions. So does this mean that I cant use Note Caddy or Note Caddy Edge in future without creating an insane size DB or was my setup wrong or something corrupted?

Moving forward can I re-enable Note Caddy and Note Caddy Edge or will I have to do without them?

Look forward to a response.

[udbrky]

That seems like a lot of space for the # of hands.

Do you have a lot of datamined hands?

Do you have a lot of active notes?

[KingDeva]

That seems like a lot of space for the # of hands.

Do you have a lot of datamined hands?

Do you have a lot of active notes?

The 900k hands is how many hands I have played there are no datamined hands in the database.

I hadnt done anything fancy with Notecaddy or adding active notes. I purchased Note Caddy to use Note Caddy Edge. Once installed Im pretty certain I didnt change anything or add extra active notes.

Can I re-enable Note Caddy and if the database grows huge again and gives me problems I can delete the notecaddy_data and notecaddy_scatter tables.

Or should I now refrain from using Note Caddy to avoid problems?

[sreticentv]

NoteCaddy updates data rather than just inserting like HM2 does which causes temporarily "lost" space in postgres. You can reclaim this space immediately by doing vacuum/analyze http://hm2faq.holdemmanager.com/questions/1171/Vacuum+Analyze+Database+

[KingDeva]

NoteCaddy updates data rather than just inserting like HM2 does which causes temporarily "lost" space in postgres. You can reclaim this space immediately by doing vacuum/analyze http://hm2faq.holdemmanager.com/questions/1171/Vacuum+Analyze+Database+

ok thanks, I will try this in future.