delete part of the database?
Results 1 to 4 of 4
  1. 12-25-2010, 05:59 AM #1
    RainbowJJ
    RainbowJJ is offline
    Member
    Join Date
    Jun 2009
    Posts
    35

    Default delete part of the database?

    I were playing on Pokerstars and Ipoker, but only on Ipoker now. I have about 600K hands from Pokerstars (about 550K is purcharged). My database is very slow when I try to refresh.

    How can I delete my cashgames hands from Pokerstars and all my tournament hands?

    I still want to be able to review the cash games hands from Ipoker. Is it possible to only delete part of the database?

    BR. RainbowJJ
    Reply With Quote Reply With Quote
  2. 12-25-2010, 06:41 AM #2
    Sarek
    Sarek is offline
    Holdem Manager Support Sarek's Avatar
    Join Date
    May 2010
    Location
    Eridani 40
    Posts
    22,519

    Default

    see this FAQ - Hold'em Manager Poker Tracking Software :: Purge Hands
    HM2 FAQ -- Quick Start HM2 Guide -- Licensing -- Postgresql issues -- Top 10 Performance Tips
    Reply With Quote Reply With Quote
  3. 12-25-2010, 01:18 PM #3
    RainbowJJ
    RainbowJJ is offline
    Member
    Join Date
    Jun 2009
    Posts
    35

    Default

    I tried that with succes and HEM is running much faster now.
    Is the hand deleted now?
    Reply With Quote Reply With Quote
  4. 12-26-2010, 06:32 AM #4
    Sarek
    Sarek is offline
    Holdem Manager Support Sarek's Avatar
    Join Date
    May 2010
    Location
    Eridani 40
    Posts
    22,519

    Default

    sincerelly said, DB needs manual vacuum
    FAQ - Hold'em Manager Poker Tracking Software :: Vacuum Analyze Database
    but make a backup first (via Pgadmin too)
    HM2 FAQ -- Quick Start HM2 Guide -- Licensing -- Postgresql issues -- Top 10 Performance Tips
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. How to delete a database?
    By wrapitup in forum Manager General
    Replies: 7
    Last Post: 09-21-2010, 09:24 AM
  2. can't delete database
    By Laugh1ngMan in forum Manager General
    Replies: 4
    Last Post: 07-12-2010, 07:56 AM
  3. Delete Database?
    By bandy in forum Manager General
    Replies: 1
    Last Post: 01-26-2009, 02:22 PM
  4. Delete database
    By transbetacism in forum Manager General
    Replies: 1
    Last Post: 12-14-2008, 03:43 PM
  5. How to delete a database?
    By euroglot in forum Manager General
    Replies: 1
    Last Post: 08-09-2008, 06:37 PM

Posting Permissions

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

Forum Rules