Message-ID: <74357b166a8e522d1a14aca7d763d0f0365df5da.camel@cybertec.at>
Subject: Re: Fwd: SQL transactions executing from VMSS
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: chandan Kumar <chandan.issyoga@gmail.com>, 
	pgsql-general@lists.postgresql.org
Date: Mon, 28 Apr 2025 11:05:31 +0200
In-Reply-To: <CAHV6zVn=8LrKPaHL4Qceq6+_jkwJzFpvvrRpVKseditBhtHrFw@mail.gmail.com>
References: 
	<CAHV6zVksAQQDiHXmDB-DHCc2Sk0fJjY_ByC4O-HQjOhUa3fOwg@mail.gmail.com>
	 <CAHV6zVn=8LrKPaHL4Qceq6+_jkwJzFpvvrRpVKseditBhtHrFw@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) 
MIME-Version: 1.0
Archived-At: <https://www.postgresql.org/message-id/74357b166a8e522d1a14aca7d763d0f0365df5da.camel%40cybertec.at>
Precedence: bulk

On Mon, 2025-04-28 at 13:55 +0530, chandan Kumar wrote:
> I did not get any answer till now.=C2=A0 If someone has any idea please h=
elp me is getting this resolved.
> The issue is - database=C2=A0deployment , sql query to database=C2=A0is s=
low when we run database script from
> vmss to postgres database=C2=A0in flexible server.=C2=A0 both the servers=
 are in US EAST under the same subnet
>=20
> 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 ser=
ver(PaaS) 14.17 version.
> VMSS to IaaS(postgres db on ubuntu) is faster than VMSs to PaaS. 14 versi=
on is same on both the
> system. response size is same but response time is almost 2.5x more on Pa=
aS. I see dynatrace is
> showing more time is on waiting time. Query plan is same on both the syst=
em. If i run single sql
> transaction from pg admin it is executing in same time.
> what can cause this slowness, any idea please.

I think that the answer you didn't get was as helpful as your problem descr=
iption:

  "I got some statement that is slow, but I will neither tell you the state=
ment nor
   show you the execution plan.  What is the cause of the slowness?"

Yours,
Laurenz Albe