MIME-Version: 1.0
References: <CAHV6zVksAQQDiHXmDB-DHCc2Sk0fJjY_ByC4O-HQjOhUa3fOwg@mail.gmail.com>
In-Reply-To: <CAHV6zVksAQQDiHXmDB-DHCc2Sk0fJjY_ByC4O-HQjOhUa3fOwg@mail.gmail.com>
From: chandan Kumar <chandan.issyoga@gmail.com>
Date: Mon, 28 Apr 2025 13:55:51 +0530
Message-ID: <CAHV6zVn=8LrKPaHL4Qceq6+_jkwJzFpvvrRpVKseditBhtHrFw@mail.gmail.com>
Subject: Fwd: SQL transactions executing from VMSS
To: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000361aa60633d26ffe"
Archived-At: <https://www.postgresql.org/message-id/CAHV6zVn%3D8LrKPaHL4Qceq6%2B_jkwJzFpvvrRpVKseditBhtHrFw%40mail.gmail.com>
Precedence: bulk

--000000000000361aa60633d26ffe
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hello Team,
I did not get any answer till now.  If someone has any idea please help me
is getting this resolved. The issue is - database deployment , sql query to
database is slow when we run database script from vmss to postgres
database in flexible server.  both the servers are in US EAST under the
same subnet

---------- Forwarded message ---------
From: chandan Kumar <chandan.issyoga@gmail.com>
Date: Tue, Apr 22, 2025 at 4:59=E2=80=AFPM
Subject: SQL transactions executing from VMSS
To: <pgsql-general@lists.postgresql.org>


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.
--=20
*With warm regards*
*     Chandan*


--=20
*With warm regards*
*     Chandan*

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

<div dir=3D"ltr">Hello Team,<div>I did not get any answer till now.=C2=A0 I=
f someone has any idea please help me is getting this resolved. The issue i=
s - database=C2=A0deployment , sql query to database=C2=A0is slow when we r=
un database script from vmss to postgres database=C2=A0in flexible server.=
=C2=A0 both the servers are in US EAST under the same subnet<br><br><div cl=
ass=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_a=
ttr">---------- Forwarded message ---------<br>From: <strong class=3D"gmail=
_sendername" dir=3D"auto">chandan Kumar</strong> <span dir=3D"auto">&lt;<a =
href=3D"mailto:chandan.issyoga@gmail.com">chandan.issyoga@gmail.com</a>&gt;=
</span><br>Date: Tue, Apr 22, 2025 at 4:59=E2=80=AFPM<br>Subject: SQL trans=
actions executing from VMSS<br>To:  &lt;<a href=3D"mailto:pgsql-general@lis=
ts.postgresql.org">pgsql-general@lists.postgresql.org</a>&gt;<br></div><br>=
<br><div dir=3D"ltr"><div><br clear=3D"all"></div><div>Hi Team,</div><div>G=
reetings!</div><div><br></div><div>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 v=
ersion. 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 tim=
e is almost 2.5x more on PaaS. I see dynatrace is showing more time is on w=
aiting time. Query plan is same on both the system. If i run single sql tra=
nsaction from pg admin it is executing in same time.</div><div>=C2=A0what c=
an cause this slowness, any idea please.</div><span class=3D"gmail_signatur=
e_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature" data-sma=
rtmail=3D"gmail_signature"><div><font style=3D"background-color:#ffffff" fa=
ce=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>
</div><div><br clear=3D"all"></div><div><br></div><span class=3D"gmail_sign=
ature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature" data=
-smartmail=3D"gmail_signature"><div><font style=3D"background-color:#ffffff=
" face=3D"comic sans ms,sans-serif" color=3D"#000099"><strong>With warm reg=
ards</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></div>

--000000000000361aa60633d26ffe--