MIME-Version: 1.0
From: Sam Stearns <sam.stearns@dat.com>
Date: Tue, 14 Oct 2025 13:32:01 -0700
Message-ID: 
 <CAN6TVjn5JkPcbxbuzrQC71uZ6xOBYZvq9f4WJh-Ka_aeZCtZ6A@mail.gmail.com>
Subject: Postgres Resource Sizing
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Cc: Avi Vallarapu <av@hexacluster.ai>, Henry Ashu <henry.ashu@dat.com>
Content-Type: multipart/alternative; boundary="0000000000005f22410641244744"
Archived-At: 
 <https://www.postgresql.org/message-id/CAN6TVjn5JkPcbxbuzrQC71uZ6xOBYZvq9f4WJh-Ka_aeZCtZ6A%40mail.gmail.com>
Precedence: bulk

--0000000000005f22410641244744
Content-Type: text/plain; charset="UTF-8"

Howdy,

We have an Oracle database that is processing 500 transactions per second
during peak hours.  We are migrating this to a Linux VM running Postgres
17.6.  Is there anything out there that can give recommendations on CPU /
memory / shared_buffer sizing based on number of transactions per second
rate?  PGTune doesn't seem to have number of transactions per second as an
option.

Thanks,

Sam

-- 

Samuel Stearns
Team Lead - Database
c: 971 762 6879 | o: 971 762 6879 | DAT.com

<https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link>

--0000000000005f22410641244744
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Howdy,</div><div><br></div><div>We have an Oracle dat=
abase that is processing 500 transactions per second during peak hours.=C2=
=A0 We are migrating this to a Linux VM running Postgres 17.6.=C2=A0 Is the=
re anything out there that can give recommendations on CPU / memory / share=
d_buffer sizing based on number of transactions per second rate?=C2=A0 PGTu=
ne doesn&#39;t seem to have number of transactions per second as an option.=
</div><div><br></div><div>Thanks,</div><div><br></div><div>Sam</div><div><b=
r></div><span class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"lt=
r" class=3D"gmail_signature" data-smartmail=3D"gmail_signature"><div dir=3D=
"ltr"><span><p dir=3D"ltr" style=3D"line-height:1.38;margin-top:10pt;margin=
-bottom:10pt"><span style=3D"font-size:11pt;font-family:Inter,sans-serif;co=
lor:rgb(51,51,51);background-color:transparent;font-weight:700;vertical-ali=
gn:baseline">Samuel Stearns</span><span style=3D"font-size:11pt;font-family=
:Inter,sans-serif;color:rgb(51,51,51);background-color:transparent;font-wei=
ght:700;vertical-align:baseline"><br></span><span style=3D"font-size:11pt;f=
ont-family:Inter,sans-serif;color:rgb(102,102,102);background-color:transpa=
rent;vertical-align:baseline">Team Lead - Database</span><span style=3D"fon=
t-size:11pt;font-family:Inter,sans-serif;color:rgb(102,102,102);background-=
color:transparent;vertical-align:baseline"><br></span><span style=3D"font-s=
ize:11pt;font-family:Inter,sans-serif;color:rgb(102,102,102);background-col=
or:transparent;vertical-align:baseline">c: 971 762 6879 </span><span style=
=3D"font-size:11pt;font-family:Inter,sans-serif;color:rgb(147,149,152);back=
ground-color:transparent;vertical-align:baseline">|</span><span style=3D"fo=
nt-size:11pt;font-family:Inter,sans-serif;color:rgb(102,102,102);background=
-color:transparent;vertical-align:baseline"> o: 971 762 6879 </span><span s=
tyle=3D"font-size:11pt;font-family:Inter,sans-serif;color:rgb(147,149,152);=
background-color:transparent;vertical-align:baseline">|</span><span style=
=3D"font-size:11pt;font-family:Inter,sans-serif;color:rgb(102,102,102);back=
ground-color:transparent;vertical-align:baseline"> DAT.com</span></p><p dir=
=3D"ltr" style=3D"line-height:1.38;margin-top:0pt;margin-bottom:0pt"><a hre=
f=3D"https://www.dat.com/?utm_medium=3Demail&amp;utm_source=3DDAT_email_sig=
nature_link" target=3D"_blank"><span style=3D"font-size:11pt;font-family:Ar=
ial,sans-serif;color:rgb(17,85,204);background-color:transparent;vertical-a=
lign:baseline"><span style=3D"border:none;display:inline-block;overflow:hid=
den;width:126px;height:54px"><img src=3D"https://lh7-rt.googleusercontent.c=
om/docsz/AD_4nXchMTXZiU3P-OkN7UwPyrdxiCAOkHWIArmSrehhAl-cXaYxECakbMV5owUfMa=
MjAZZcbjttr8pEtSGrZjUSRNaxbLxumAthLgYlFE5iT2P2eOJu4jtqizp_fYM0Mq1DZyFUeHMhp=
GKjiGIzqD_ny_hPIzlt?key=3Dz3dM0-Cr9WzKyLauPVBgWw" width=3D"126" height=3D"5=
4" style=3D"margin-left:0px;margin-top:0px"></span></span></a></p><div><br>=
</div></span></div></div></div>

--0000000000005f22410641244744--