jasmin97
11-23-2010, 10:19 PM
hi
i run:
windows 7 x64
hem 1.11.05b
postgres sql 8.3
i purged 6 million hands last week from 2009
than i made a manual vaccum following exactly the faq : FAQ - Hold'em Manager Poker Tracking Software :: Vacuum Analyze Database (http://faq.holdemmanager.com/questions/88/Vacuum+Analyze+Database+)
1. it took half a day and i got the following message in the end:
"DETAIL: A total of 204800 page slots are in use (including overhead).
733520 page slots are required to track all free space.
Current limits are: 204800 page slots, 1000 relations, using 1269 kB.NOTICE: number of page slots needed (733520) exceeds max_fsm_pages (204800)
HINT: Consider increasing the configuration parameter "max_fsm_pages" to a value over 733520.
Gesamtlaufzeit der Abfrage: 55754764 ms."
is that good or bad???
2. I had no speed problems but my intention was to save disk space however since the vaccum hem won't load the hands or it will take ages. It shows my sessions for the last 3 or whatever days in no time but below where the last 100 or 500 hands are supposed to be it is empty or takes 10 or more minutes to load. Same in the reports section. Graph is okay it just takes some time to graph 1mio+ hands.
what should i do? help needed!
i run:
windows 7 x64
hem 1.11.05b
postgres sql 8.3
i purged 6 million hands last week from 2009
than i made a manual vaccum following exactly the faq : FAQ - Hold'em Manager Poker Tracking Software :: Vacuum Analyze Database (http://faq.holdemmanager.com/questions/88/Vacuum+Analyze+Database+)
1. it took half a day and i got the following message in the end:
"DETAIL: A total of 204800 page slots are in use (including overhead).
733520 page slots are required to track all free space.
Current limits are: 204800 page slots, 1000 relations, using 1269 kB.NOTICE: number of page slots needed (733520) exceeds max_fsm_pages (204800)
HINT: Consider increasing the configuration parameter "max_fsm_pages" to a value over 733520.
Gesamtlaufzeit der Abfrage: 55754764 ms."
is that good or bad???
2. I had no speed problems but my intention was to save disk space however since the vaccum hem won't load the hands or it will take ages. It shows my sessions for the last 3 or whatever days in no time but below where the last 100 or 500 hands are supposed to be it is empty or takes 10 or more minutes to load. Same in the reports section. Graph is okay it just takes some time to graph 1mio+ hands.
what should i do? help needed!