Huge Database Size 486 GB for 900k hands - Note Caddy Problem?
Results 1 to 5 of 5
  1. #1
    Junior Member
    Join Date
    May 2013
    Posts
    8

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

    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/gene...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.

  2. #2
    You're out! udbrky's Avatar
    Join Date
    Jul 2008
    Posts
    20,898

    Default

    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?

  3. #3
    Junior Member
    Join Date
    May 2013
    Posts
    8

    Default

    Quote Originally Posted by udbrky View Post
    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?

  4. #4
    NoteCaddy sreticentv's Avatar
    Join Date
    Dec 2009
    Location
    No direction but to trust the final destination
    Posts
    6,481

    Default

    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/ques...lyze+Database+
    NoteCaddy Manual | Coaching Packs | Blog
    NoteCaddy experts: a.k.aAlso, Catalyst_Kh, Derders, karstenkloss, scoobediah (NoteCaddy Edge)

  5. #5
    Junior Member
    Join Date
    May 2013
    Posts
    8

    Default

    Quote Originally Posted by sreticentv View Post
    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/ques...lyze+Database+
    ok thanks, I will try this in future.

Similar Threads

  1. Replies: 9
    Last Post: 05-27-2014, 06:42 PM
  2. 3m hands + Note Caddy taking too much space?
    By zeneil in forum NoteCaddy
    Replies: 11
    Last Post: 02-22-2013, 01:11 PM
  3. Replies: 2
    Last Post: 08-09-2012, 07:46 AM
  4. Huge database problem
    By hindukush in forum Manager General
    Replies: 1
    Last Post: 08-29-2010, 05:51 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •