Postgresql Data space.

[McNulty]

I have been using your product for quite a while and have version 8.3 of sql installed. There is now over 20gig of hand history data stored and I think its causing my (very old) computer to slow down. Is there a way of purging some of the data without losing my database or how do I copy it to my external hard drive succesfully?

Many thanks.

[netsrak]

To gain some space you can purge old hands and then do a vacuum/full.

See our performance tips too: Top 10: HEM performance increase tips - Holdem Manager Forums

You can delete all files in the postgresql subfolder pg_log. After that you can disable this logging permanently FAQ - Hold'em Manager Poker Tracking Software :: Large Log Files

To move the database to a separate HDD: FAQ - Hold'em Manager Poker Tracking Software :: Move Database to Another Hard Drive or Partition

[McNulty]

To gain some space you can purge old hands and then do a vacuum/full.

See our performance tips too: Top 10: HEM performance increase tips - Holdem Manager Forums

You can delete all files in the postgresql subfolder pg_log. After that you can disable this logging permanently FAQ - Hold'em Manager Poker Tracking Software :: Large Log Files

To move the database to a separate HDD: FAQ - Hold'em Manager Poker Tracking Software :: Move Database to Another Hard Drive or Partition

Many thanks for your help. So should I delete the files or the folder itself C:\Program Files\PostgreSQL\8.3\data\pg_log? Thanks.

[morny]

Only delete the files not the folder