On 4/28/25 01:25, chandan Kumar wrote:
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
1) Unravel the acronyms. I'm pretty sure VMSS and Flexible server are
referring to Azure services, but it would be better if that was
explicitly stated.
2) Show your work. In other words include the query plan, database
script and the dynatrace results in your response.
3) What is "If i run single sql transaction from pg admin
it is executing in same time." trying to say? The same query as you
refer to earlier and how does a single query relate to the issue of
running transactions in batches?
My guess is that the Flexible Server(PaaS) is imposing more of an
overhead then running your own Postgres instance on IaaS(Azure?).
---------- Forwarded message ---------
From: *chandan Kumar* <chandan.issy...@gmail.com
<mailto:chandan.issy...@gmail.com>>
Date: Tue, Apr 22, 2025 at 4:59 PM
Subject: SQL transactions executing from VMSS
To: <pgsql-general@lists.postgresql.org
<mailto: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.
--
*With warm regards*
* Chandan*
--
*With warm regards*
* Chandan*
--
Adrian Klaver
adrian.kla...@aklaver.com
