Thanks for all of the info guys. Sadly, i'm still a little confused :) What i'm looking for is building a fast and reliable PC for my purposes while getting the best bang for buck. I don't mind paying 500$, 1000$ or 2000$ if its WORTH it(i.e i'm looking for the point where paying extra won't effect my needs much). Sure, getting an i7, 32gb 2133mhz cl7, 2*SSD in raid 1, an extrnal UPS for protection etc will be best, but is it necessary for me or is it an overkill? CPU: I'm still not sure what should I get. If i understand correctly Greg message, despite my workload, i7 won't have much benefit for me and I should get i5(i7=4 cores with HT=8, i5=4 cores)? RAM: >From Scot/Craig I understood that I'm going to want to have my whole DB fit into my RAM. But I don't think it is possible, even with 16GB RAM. From Greg I understood that I only need the data that is being processed to fit into my RAM. So i'm a bit confused. Should I get 8GB or 16GB? SSD: This one is the most tricky. I read that consumer SSD is not reliable enough(can have BSOD, can cause in data corruption, in case of power shutdown data might be lost etc), also I read that SQL will tear-up a consumer SSD. Therefore i'm not sure what should I do. Getting 2 7200 rpm hdd's in raid 0 will still cause big bottleneck right? Getting an SSD and UPS for power shutdown protection should cut it or is it still not reliable enough and prone to failure(or slowing down due to massive write)? What should I do? Thanks. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Building-an-home-computer-for-best-Poker-Tracker-performance-tp4597798p4619783.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
