Hi Team,
We are thinking of shifting our data warehouse solution from Netezza to PostgreSQL. I am reading a lot about PostgreSQL lately. Can you please let us know the minimum[overall performance should be good] hardware requirements for the below mentioned statistics. My question is actually divided into two parts. 1. What hardware entities[RAM, Storage, Disk, RAID level etc. ] should we keep in mind while finalizing the requirement? Sorry for my ignorance here as I am totally new to this territory. 2. What should be the plan of action for performance benchmarking? 3. What should be the minimum hardware requirements for doing a POC and comparing performance benchmark with Netezza? *Parameter* *Numbers on 7th Dec 2014* Total number of Users 222 Total number of Application Users 110 Individual Accounts 112 Total number of Successful Queries on 7 December 425124 Total number of Unsuccessful Queries 2591 Maximum number of Queries in an *Hour* 79920 Maximum number of Queries in a *minute* when load was maximum in an hour 3143 Maximum number of Queries in a *second* when load was maximum in an hour 87 Number of Databases 82 Used Space ~1057 GB Allocated Space ~4453 GB *What I actually want to achieve is right now is that running the same load on Netezza and PostgreSQL [300 GB data, 20 concurrent queries, and 30k-40K queries in an hour]. * I have asked for the following configuration right now. *Operating System* (Linux 64 bit) *RAM* : 8 GB *Storage*: 500 GB *CPU Cores*: Minimum 4 *RAID*: Level 10 *Disk Type*: SATA These figures are for POC only. Does that sound okay? Once again, my trivial questions could be irritating but this is only a start. Warm Regards, Vivekanand Joshi +919654227927 [image: Zeta Interactive] 185 Madison Ave. New York, NY 10016 www.zetainteractive.com
