Date: Mon, 4 Feb 2019 15:56:45 +0100 (CET)
From: Andreas Joseph Krogh <andreas@visena.com>
To: pgsql-performance@lists.postgresql.org
Message-ID: <VisenaEmail.38.73d479ddee0ddb2c.168b900e5e0@tc7-visena>
In-Reply-To: 
 <CAON0Day=M6164EehJo1M-CS95c22fpGrArm_pVwJ9tjzaRYujg@mail.gmail.com>
Subject: Sv: Re: Fw: server hardware tuning.
MIME-Version: 1.0
Content-Type: multipart/mixed;
	boundary="----=_Part_240_1676285791.1549292205881"
Precedence: bulk

------=_Part_240_1676285791.1549292205881
Content-Type: multipart/related;
	boundary="----=_Part_241_1226404481.1549292205881"

------=_Part_241_1226404481.1549292205881
Content-Type: multipart/alternative;
	boundary="----=_Part_242_1451660607.1549292205892"

------=_Part_242_1451660607.1549292205892
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

P=C3=A5 mandag 04. februar 2019 kl. 15:45:30, skrev Prince Pathria <
prince.pathria@goevive.com <mailto:prince.pathria@goevive.com>>: Hi=C2=A0Su=
ganthi, I=20
can give you a start, some pro users can suggest you better. =C2=A0 1. Don'=
t use=20
this much of connections on a single postgres server. Use a connection pool=
er=20
in front of it. 2. RAM: Depends upon how much data you want to be cached. 3=
.=20
Use PCIe SATA SSD with RAID10, Postgres uses a lot of IO for its operations=
.=C2=A0=20
4. For config tuning:=C2=A0https://pgtune.leopard.in.ua/#/=20
<https://pgtune.leopard.in.ua/#/> Though please go through all params for m=
ore=20
understanding =C2=A0 Happy to help :) Prince Pathria Systems Architect Inte=
rn Evive=20
+91 9478670472goevive.com <http://goevive.com> =C2=A0 There's no such thing=
 as PCIe=20
SATA, use PCIe or=C2=A0NVMe in RAID-10, it's quite affordable these days an=
d=20
meaningless not to use. =C2=A0 --
 Andreas Joseph Krogh
------=_Part_242_1451660607.1549292205892
Content-Type: text/html;charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div>P=C3=A5 mandag 04. februar 2019 kl. 15:45:30, skrev Prince Pathria &lt=
;<a href=3D"mailto:prince.pathria@goevive.com">prince.pathria@goevive.com</=
a>&gt;:</div>

<blockquote style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt=
 0pt 0pt 0.8ex; padding-left: 1ex;">
<div dir=3D"ltr">
<div dir=3D"ltr">
<div dir=3D"ltr">Hi=C2=A0Suganthi,
<div>I can give you a start, some pro users can suggest you better.</div>

<div>=C2=A0
<div>1. Don't use this much of connections on a single postgres server. Use=
 a connection pooler in front of it.</div>

<div>2. RAM: Depends upon how much data you want to be cached.</div>

<div>3. Use PCIe SATA SSD with RAID10, Postgres uses a lot of IO for its op=
erations.=C2=A0</div>

<div>4. For config tuning:=C2=A0<a href=3D"https://pgtune.leopard.in.ua/#/"=
>https://pgtune.leopard.in.ua/#/</a> Though please go through all params fo=
r more understanding</div>

<div>=C2=A0
<div>
<div class=3D"gmail_signature" dir=3D"ltr">
<div dir=3D"ltr">
<div>
<div dir=3D"ltr">
<div>
<div dir=3D"ltr">
<div><span style=3D"font-size:11.3333px;white-space:pre-wrap;color:rgb(136,=
136,136);font-family:Arial">Happy to help :)</span></div>

<div><font color=3D"#888888" face=3D"Arial"><span style=3D"font-size:11.333=
3px;white-space:pre-wrap">Prince Pathria Systems Architect Intern Evive +91=
 9478670472 <a href=3D"http://goevive.com" target=3D"_blank">goevive.com</a=
></span></font></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>

<div>=C2=A0</div>

<div>There's no such thing as PCIe SATA, use PCIe or=C2=A0NVMe in RAID-10, =
it's quite affordable these days and meaningless not to use.</div>

<div>=C2=A0</div>

<div class=3D"visena-email-signature" data-visena-message-id=3D"&lt;VisenaE=
mail.38.73d479ddee0ddb2c.168b900e5e0@tc7-visena>">
<div>--<br>
Andreas Joseph Krogh</div>
</div>
------=_Part_242_1451660607.1549292205892--

------=_Part_241_1226404481.1549292205881--

------=_Part_240_1676285791.1549292205881--