From: Vivekanand Joshi <vjoshi@zetainteractive.com>
To: pgsql-performance@postgresql.org
Subject: Hardware Requirements
Date: Wed, 10 Dec 2014 00:12:46 +0530
Message-ID: <7e78438b6afe2edf8077793522fa30fd@mail.gmail.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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:image001.png (image/png, 184B) downloadview image
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: vjoshi@zetainteractive.com
Subject: Re: Hardware Requirements
In-Reply-To: <7e78438b6afe2edf8077793522fa30fd@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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