public inbox for [email protected]
help / color / mirror / Atom feedFrom: chandan Kumar <[email protected]>
To: [email protected]
Subject: Fwd: SQL transactions executing from VMSS
Date: Mon, 28 Apr 2025 13:55:51 +0530
Message-ID: <CAHV6zVn=8LrKPaHL4Qceq6+_jkwJzFpvvrRpVKseditBhtHrFw@mail.gmail.com> (raw)
In-Reply-To: <CAHV6zVksAQQDiHXmDB-DHCc2Sk0fJjY_ByC4O-HQjOhUa3fOwg@mail.gmail.com>
References: <CAHV6zVksAQQDiHXmDB-DHCc2Sk0fJjY_ByC4O-HQjOhUa3fOwg@mail.gmail.com>
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 <[email protected]>
Date: Tue, Apr 22, 2025 at 4:59 PM
Subject: SQL transactions executing from VMSS
To: <[email protected]>
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*
--
*With warm regards*
* Chandan*
view thread (5+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Fwd: SQL transactions executing from VMSS
In-Reply-To: <CAHV6zVn=8LrKPaHL4Qceq6+_jkwJzFpvvrRpVKseditBhtHrFw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox