Hardware for database

pingvvino

Honorable
Feb 8, 2013
3
0
10,510
I'm looking for a server which will handle Postgresql 9.0 database with the following specification:

400 queries per minutes per user
100 GB database
20 mln rows in table
40-60 clients connected simultaneously

Ideally database will be store on SSD drive.
 

camohanna

Distinguished
I dont really know too much about servers except you will need a Xeon core :p

PCPartPicker part list: http://pcpartpicker.com/p/DWiP
Price breakdown by merchant: http://pcpartpicker.com/p/DWiP/by_merchant/
Benchmarks: http://pcpartpicker.com/p/DWiP/benchmarks/

CPU: Intel Xeon E3-1230 V2 3.3GHz Quad-Core Processor ($233.98 @ SuperBiiz)
Motherboard: ASRock Z77 Extreme4 ATX LGA1155 Motherboard ($119.99 @ Amazon)
Memory: Corsair Vengeance 16GB (2 x 8GB) DDR3-1600 Memory ($79.99 @ Amazon)
Storage: Plextor PX-M3S Series 256GB 2.5" Solid State Disk ($297.24 @ Mwave)
Video Card: MSI Radeon HD 7750 2GB Video Card ($88.48 @ SuperBiiz)
Case: Cooler Master HAF 912 ATX Mid Tower Case ($56.21 @ TigerDirect)
Power Supply: Corsair Builder 430W 80 PLUS Bronze Certified ATX12V Power Supply ($26.99 @ Newegg)
Total: $902.88
(Prices include shipping, taxes, and discounts when available.)
(Generated by PCPartPicker 2013-02-16 16:52 EST-0500)