Build for a large GIS database

[akreider]

I'm thinking of getting a new computer to handle a 40 GB PostGIS database which I'm using to create a million tiles using TileMill (aka Mapnik).

I also want to handle mild gaming (Civ 5, Starcraft), and to be relatively power efficient.

I want it to be affordable (under $1000), but also reliable.

I might give away my old computer, instead of cannibalizing it for parts.

My current computer (Dell Inspiron 530 with upgrades)
-Q6600
-3GB Ram
-500 GB HD
-128 GB SSD with operating system and postgis database
-Windows 8 (32 bit)
-ATI Radeon 5570, 1 GB
-2 monitors (1400x900 and 1024x768)
-external 2 TB for backups
-antec 380 watts (bronze plus)


New computer brainstorm
-CPU: I5 4670 - $220

-Motherboard: I need: LGA 1155, micro Atx, supports 32 GB RAM. Don't need overclocking. MSI B75MA-P45 for $67 at Amazon.com

-16 GB ram: $130
Crucial 2x8 GB

-Windows 8 64 bit - $15 (Buy backup DVD from Microsoft)

-3 TB internal HD - $130
http://amzn.com/B005T3GRLY ]Seagate Barracuda 3 TB [/url]

-256 GB SSD - $186
Samsung]http://amzn.com/B00E3W1726]Samsung Electronics 840 [/url]

-Video: keep the Radeon 5570.
-Power supply: keep the Antec 380
-Case: keep the Dell case

 

[oczdude8]

just a point, a lower wattage psu doesn't mean better efficiency. A system will only draw whatever power it needs, i.e a system will draw 300w regardless of if its running a 400w psu or a 1250w psu.

if you want efficient, you have to look for 80+ certified psus. Some are as much as 90% efficient. This efficiency is measured based on how much power is draws from the plug relative to what is being used by the system.

so if you have a system that needs 300W, 70% efficient psu will draw 390W, while a 90% will draw 330W. (both still only provide 300W of usable power)

A psu always draw more power then it is providing to components, since the process of converting ac to dc can never be 100% efficient.

 

[akreider]

That is a fair point. Though the other part of efficiency is making sure I don't buy stuff I don't need to reduce the impact on the environment and to keep the case lighter.

I updated my thoughts on this build. I've never done this before, so I could use some assistance =) I want to be sure that the parts are at least compatible.

 

[oczdude8]

looks pretty good, BUT you need a socket 1150 motherboard for sure. the one you posted is not compatible.

 

[oczdude8]

I would recommend this :http://www.amazon.com/Gigabyte-1150-CrossFireX-Motherboard-GA-H87-D3H/dp/B00CU4L3AU/ref=sr_1_4?s=electronics&ie=UTF8&qid=1379459846&sr=1-4&keywords=1150+motherboard
or
http://www.amazon.com/ASUS-B85M-E-CSM-DDR3-Motherboard/dp/tech-data/B00CRJU2X2/ref=de_a_smtd

 

[akreider]

Ahh the lower numbered socket is the new model. I was expecting it'd go the other way.