aamonstr
11-06-2010, 06:44 PM
Hello to all. First of all sorry for my bad english. :)
I have remote server with postgreSQL 8.4 installed and HoldemManager on it (updated every new patch). Have some users playing from this base. Server is core 2 duo, ssd harddrive, 8gb ram, windows 7 64bt.
I use "autoimort" for maning hands on server side. When i create new base all work perfectly. Then when size of database up to 40-50gb it stars make errors in autoimport. At the start it make not so much errors (about 5-10% of all hands). Then number or errors up and up (and make it about 60-80% from all imported hands).
I try make vacum and reindex of database. It doesnt help. (after reindex it can work without errors 5-30 hours and then stars errors again). I try create new database and make backup. Nothing. So when i make import in new base all work. When size up for 40-50 gb start this problem.
1)What i can to do? (Because i cant make reindex every 5-10 hourse)
2)May be the problem is that 4-5 people conects to database? (i use the same account postgress for all of them).
I have remote server with postgreSQL 8.4 installed and HoldemManager on it (updated every new patch). Have some users playing from this base. Server is core 2 duo, ssd harddrive, 8gb ram, windows 7 64bt.
I use "autoimort" for maning hands on server side. When i create new base all work perfectly. Then when size of database up to 40-50gb it stars make errors in autoimport. At the start it make not so much errors (about 5-10% of all hands). Then number or errors up and up (and make it about 60-80% from all imported hands).
I try make vacum and reindex of database. It doesnt help. (after reindex it can work without errors 5-30 hours and then stars errors again). I try create new database and make backup. Nothing. So when i make import in new base all work. When size up for 40-50 gb start this problem.
1)What i can to do? (Because i cant make reindex every 5-10 hourse)
2)May be the problem is that 4-5 people conects to database? (i use the same account postgress for all of them).