PDA

View Full Version : Postgresql Data space.



McNulty
04-26-2010, 04:31 AM
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
04-26-2010, 06:48 AM
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 (http://forums.holdemmanager.net/showthread.php?t=11194)

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 (http://faq.holdemmanager.com/questions/85/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 (http://faq.holdemmanager.com/questions/368/Move+Database+to+Another+Hard+Drive+or+Partition)

McNulty
04-26-2010, 09:13 AM
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 (http://forums.holdemmanager.net/showthread.php?t=11194)

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 (http://faq.holdemmanager.com/questions/85/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 (http://faq.holdemmanager.com/questions/368/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
04-26-2010, 11:09 AM
Only delete the files not the folder