dare_v
04-17-2010, 01:14 PM
I've recently started to daily import high amount of hands (~50.000) and its causing me huge performance drop and very slow hands import.
My machine is Core 2 Duo 2Ghz, 3GB of RAM and a SSD drive. Running Win 7 64 bit with PostreSQL 3.4 installed.
I've read the long thread about tips to improve performance, but nothing seems to help.
I vacuum database each day, after I finish playing and before I import batch of hands.
Each time the start of importing is quite fast (~50h/s), but after some minutes, it drops drasticly, down to 2h/s.
I am sure I am not the only one doing this and would like to hear from other people too, what is their import speed and if there are any ideas how to improve my import speed. The most important thing would be to prevent import speed decreasing, I am fine with 50h/s speed, if it would stick there.
I doubt that even I7 cpu and RAID 0 with SSD would improve anything, it seems to me there is some cache error, or its just postresql thingy?
My machine is Core 2 Duo 2Ghz, 3GB of RAM and a SSD drive. Running Win 7 64 bit with PostreSQL 3.4 installed.
I've read the long thread about tips to improve performance, but nothing seems to help.
I vacuum database each day, after I finish playing and before I import batch of hands.
Each time the start of importing is quite fast (~50h/s), but after some minutes, it drops drasticly, down to 2h/s.
I am sure I am not the only one doing this and would like to hear from other people too, what is their import speed and if there are any ideas how to improve my import speed. The most important thing would be to prevent import speed decreasing, I am fine with 50h/s speed, if it would stick there.
I doubt that even I7 cpu and RAID 0 with SSD would improve anything, it seems to me there is some cache error, or its just postresql thingy?