pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Hardware Requirements 2+ messages / 2 participants [nested] [flat]
* Hardware Requirements @ 2014-12-09 18:42 Vivekanand Joshi <vjoshi@zetainteractive.com> 2014-12-09 18:55 ` Re: Hardware Requirements Claudio Freire <klaussfreire@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: Vivekanand Joshi @ 2014-12-09 18:42 UTC (permalink / raw) To: pgsql-performance 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 Attachments:^ permalink raw reply [nested|flat] 2+ messages in threadimage001.png (image/png, 184B) download
view image
* Re: Hardware Requirements 2014-12-09 18:42 Hardware Requirements Vivekanand Joshi <vjoshi@zetainteractive.com> @ 2014-12-09 18:55 ` Claudio Freire <klaussfreire@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Claudio Freire @ 2014-12-09 18:55 UTC (permalink / raw) To: vjoshi@zetainteractive.com; +Cc: pgsql-performance On Tue, Dec 9, 2014 at 3:42 PM, Vivekanand Joshi <vjoshi@zetainteractive.com > wrote: > 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]. You will need to provide far more information about the type of queries you're referring to. Querying one single row against a PK isn't the same as performing complex analytics on big chunks of historical data. ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2014-12-09 18:55 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2014-12-09 18:42 Hardware Requirements Vivekanand Joshi <vjoshi@zetainteractive.com> 2014-12-09 18:55 ` Claudio Freire <klaussfreire@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox