MIME-Version: 1.0
From: chandan Kumar <chandan.issyoga@gmail.com>
Date: Tue, 22 Apr 2025 16:59:31 +0530
Message-ID: <CAHV6zVksAQQDiHXmDB-DHCc2Sk0fJjY_ByC4O-HQjOhUa3fOwg@mail.gmail.com>
Subject: SQL transactions executing from VMSS
To: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000001bfb5806335c4df3"
Archived-At: <https://www.postgresql.org/message-id/CAHV6zVksAQQDiHXmDB-DHCc2Sk0fJjY_ByC4O-HQjOhUa3fOwg%40mail.gmail.com>
Precedence: bulk

--0000000000001bfb5806335c4df3
Content-Type: text/plain; charset="UTF-8"

Hi Team,
Greetings!

Kindly help in below situation, where in I see slowness in response time
while I do testing running SQL transaction in batches from VMSS to postgres
database in flexible server(PaaS) 14.17 version. VMSS to IaaS(postgres db
on ubuntu) is faster than VMSs to PaaS. 14 version is same on both the
system. response size is same but response time is almost 2.5x more on
PaaS. I see dynatrace is showing more time is on waiting time. Query plan
is same on both the system. If i run single sql transaction from pg admin
it is executing in same time.
 what can cause this slowness, any idea please.
-- 
*With warm regards*
*     Chandan*

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

<div dir=3D"ltr"><div><br clear=3D"all"></div><div>Hi Team,</div><div>Greet=
ings!</div><div><br></div><div>Kindly help in below situation, where in I s=
ee slowness in response time while I do testing running SQL transaction in =
batches from VMSS to postgres database in flexible server(PaaS) 14.17 versi=
on. VMSS to IaaS(postgres db on ubuntu) is faster than VMSs to PaaS. 14 ver=
sion is same on both the system. response size is same but response time is=
 almost 2.5x more on PaaS. I see dynatrace is showing more time is on waiti=
ng time. Query plan is same on both the system. If i run single sql transac=
tion from pg admin it is executing in same time.</div><div>=C2=A0what can c=
ause this slowness, any idea please.</div><span class=3D"gmail_signature_pr=
efix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature" data-smartma=
il=3D"gmail_signature"><div><font style=3D"background-color:#ffffff" face=
=3D"comic sans ms,sans-serif" color=3D"#000099"><strong>With warm regards</=
strong></font></div>
<div><font style=3D"background-color:#ffffff" face=3D"comic sans ms,sans-se=
rif" color=3D"#000099"><strong>=C2=A0=C2=A0=C2=A0=C2=A0 Chandan</strong></f=
ont></div></div></div>

--0000000000001bfb5806335c4df3--