SQL transactions executing from VMSS

From: chandan Kumar <chandan(dot)issyoga(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: SQL transactions executing from VMSS
Date: 2025-04-22 11:29:31
Message-ID: CAHV6zVksAQQDiHXmDB-DHCc2Sk0fJjY_ByC4O-HQjOhUa3fOwg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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*

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2025-04-22 11:54:44 Re: Oracle_fdw
Previous Message Yongye Serkfem 2025-04-22 11:28:33 Oracle_fdw