Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XyPkN-0004vW-EP for pgsql-performance@arkaria.postgresql.org; Tue, 09 Dec 2014 18:42:55 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XyPkM-0002fp-Vr for pgsql-performance@arkaria.postgresql.org; Tue, 09 Dec 2014 18:42:54 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XyPkL-0002fi-IN for pgsql-performance@postgresql.org; Tue, 09 Dec 2014 18:42:53 +0000 Received: from mail-oi0-x22e.google.com ([2607:f8b0:4003:c06::22e]) by magus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1XyPkF-0006PZ-HV for pgsql-performance@postgresql.org; Tue, 09 Dec 2014 18:42:51 +0000 Received: by mail-oi0-f46.google.com with SMTP id h136so828657oig.33 for ; Tue, 09 Dec 2014 10:42:45 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=zetainteractive.com; s=google; h=reply-to:from:mime-version:thread-index:date:message-id:subject:to :content-type; bh=IxrNcebpDcJGcKK1+Xj0L7Wq4GRbqeBpOsVbHt2JJaY=; b=NHlZYg7X8voZaYR47bBEJns2bVS0n+7NYS16iHN6iy3mL8BRDqeJkXW/YYKz4ZNtkl NPwL1QkkdH67SYRaYuZS2v24ZjOW5+bfvi9ARe/b2ZNzFi+DQWK7xvMS9g5vX5mtbXhT AYPkD9pLteSwPaHYK9FWt8vj/gCp+gtSkdvMk= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:reply-to:from:mime-version:thread-index:date :message-id:subject:to:content-type; bh=IxrNcebpDcJGcKK1+Xj0L7Wq4GRbqeBpOsVbHt2JJaY=; b=lwmkcuc4EPnt3jkqZQLtHCRkSqgQ9oXjI8+9ivTcAROiv4X3UvBpJRKpaL7FgFGPjh DEeXmYPCw1shOhjX0wGQR0BWxyd+/UVco+Mec73tXWdpF9yL3L8NX5L85ByFtLwJCZYy GsIcNGnNmvjoq7h6Qevl/wdfPrmr5Fkwb5eKWSSQc2NDq3TUaMeVEjdckBofg4nNwrCF AZYUyqiI9n+xkthlue/YXDXZZ1I0F6PvJSEMYRxpqnAihpRGkzzRTeGuf8+IdzzbB9/k z1atqOW0zQlxJrMQ4jJp2T1cO7wyfipxLv3ZOrnDaPYy/OitrbWlgpMZP92f1+UaxOoB s6lA== X-Gm-Message-State: ALoCoQmaZHlfJEopBSiuGlvJ7Wi16QS4gTie6ryq/P01db6jYD/GcFat0SiSpXY0x8VEpApRPWoK X-Received: by 10.60.65.99 with SMTP id w3mr12283051oes.6.1418150565086; Tue, 09 Dec 2014 10:42:45 -0800 (PST) Reply-To: From: Vivekanand Joshi MIME-Version: 1.0 X-Mailer: Microsoft Outlook 15.0 thread-index: AdAT37V0bvfApO69RHqXUTuVI9zppA== Date: Wed, 10 Dec 2014 00:12:46 +0530 Message-ID: <7e78438b6afe2edf8077793522fa30fd@mail.gmail.com> Subject: Hardware Requirements To: pgsql-performance@postgresql.org Content-Type: multipart/related; boundary=001a11c24a32abb60b0509cce86b X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org --001a11c24a32abb60b0509cce86b Content-Type: multipart/alternative; boundary=001a11c24a32abb6070509cce86a --001a11c24a32abb6070509cce86a Content-Type: text/plain; charset=UTF-8 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 --001a11c24a32abb6070509cce86a Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable <= div class=3D"WordSection1">

Hi Team,

=C2=A0

We are thinking of shifting our = data warehouse solution from Netezza to PostgreSQL. I am reading a lot abou= t PostgreSQL lately.

=C2=A0

Can you please let us know the minimum[overall performance should be g= ood] hardware requirements for the below mentioned statistics. My question = is actually divided into two parts.

=C2=A0

1.=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 What hardware entities[RAM, Storage, Disk, RAID level etc. ] should we k= eep in mind while finalizing the requirement? Sorry for my ignorance here a= s I am totally new to this territory.

2.=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 What should be the plan of = action for performance benchmarking?

3.=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 What should be the minimum = hardware requirements for doing a POC and comparing performance benchmark w= ith Netezza?

=C2=A0

Parameter

79920

=C2=A0

What I actual= ly want to achieve is right now is that running the same load on Netezza an= d PostgreSQL [300 GB data, 20 concurrent queries, and 30k-40K queries in an= hour].

=C2=A0

I h= ave asked for the following configuration right now.

=C2=A0

Operating System (Linux 64 bit)=

RAM : 8 GB

S= torage: 500 GB

CPU Cores: Minimum 4

RAID: Level 10

= Disk Type: SATA

=C2=A0

These figures are for POC only.

=C2=A0

Does that sound okay? Once again, my trivial questions= could be irritating but this is only a start.

= =C2=A0

Warm Regards,=


Vivekanand Joshi
+919654227927=

=C2=A0

3D"Zeta

185 Madison Ave. New York, NY 10016

www.= zetainteractive.com

= =C2=A0

--001a11c24a32abb6070509cce86a-- --001a11c24a32abb60b0509cce86b Content-Type: image/png; name="image001.png" Content-Disposition: inline; filename="image001.png" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: 275c8e954b824666_0.1 iVBORw0KGgoAAAANSUhEUgAAAIMAAAAoCAMAAADqmLl5AAAAAXNSR0ICQMB9xQAAAANQTFRFAAAA p3o92gAAAAF0Uk5TAEDm2GYAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAAZdEVYdFNvZnR3YXJlAE1p Y3Jvc29mdCBPZmZpY2V/7TVxAAAAHElEQVRYw+3BMQEAAADCoPVPbQwfoAAAAAAAPgYUoAAB8eFV /wAAAABJRU5ErkJggg== --001a11c24a32abb60b0509cce86b--

Numbers on = 7th Dec 2014

Total n= umber of Users

222

Total= number of Application Users

110

Individual Accounts

112

Total number of Successful Queries on 7 December

425124

<= /td>

Total number of Unsuccessful Queries<= /span>

2591

Maximum number of Qu= eries in an Hour

Maximum number of Queries in a= minute when load was maximum in an hour

3143

Maximum number of Queries in a second when lo= ad was maximum in an hour

87

Number of Databases

82

Used Space

~1057 GB

Allocated Space

~4453 GB